SEARCH

 

LOWER Function

LOWER returns a string that is the same as the 1st argument with all the characters in lowercase.

The argument to LOWER can be a CHAR, VARCHAR2, NCHAR, NVARCHAR2, CLOB or NCLOB.

Example:

SELECT LOWER('Oracle Rocks') as RESULT FROM DUAL;

RESULT
----------------
oracle rocks

Add your comments or share tips on Lower

 

Top

 
   Copyright © 2002-2008 OracleHome.co.uk All rights are reserved.