LOWER and UPPER
The LOWER function converts expressions of type CHAR, NCHAR, VARCHAR2, NVARCHAR2, CLOB, or NCLOB to lowercase. The UPPER function converts expressions of type CHAR, NCHAR, VARCHAR2, NVARCHAR2, CLOB, or NCLOB to uppercase. Character semantics are supported for CHAR and VARCHAR2 types. The data type of the result is the same as the data type of the expression.
SQL syntax
{UPPER | LOWER} (Expression1)Parameters
LOWER and UPPER have the following parameter:
| Parameter | Description |
|---|---|
|
|
An expression which is converted to lowercase (using |
Description
LOWER(?) and UPPER(?) are not supported, but you can combine it with the CAST operator. For example:
LOWER(CAST(? AS CHAR(30)))
Command> SELECT LOWER (last_name) FROM employees WHERE employee_id = 100;
< king >
1 row found.