In Oracle/PLSQL, the lower function converts all letters in the specified string to lowercase. If there are characters in the string that are not letters, they are unaffected by this function.
Syntax
The syntax for the lower function is:
lower( string1 )
string1 is the string to convert to lowercase.
Applies To
For Example
| lower('Tech on the Net'); | would return 'tech on the net' |
| lower('GEORGE BURNS 123 '); | would return 'george burns 123 ' |