NLS_LOWER Function in PL/SQL
NLS_LOWER function returns a string with eache letter in lower case corresponding to the input string given.
<strong>Syntax for uisng NLS_LOWER Function</strong>
NLS_LOWER( ‘string’,'nlsparam’);
Both string and 'nlsparam' can be CHAR, VARCHAR2, NCHAR, NVARCHAR2, CLOB, or NCLOB. The output returned is of VARCHAR2 datatype if string is a character datatype and a LOB if string is a LOB datatype.
The 'nlsparam' can have the same form and serve the same purpose as in the NLS_INITCAP function.
The following Query returns the character string ‘New City'‘ using the XFrench linguistic sort sequence:
SELECT NLS_LOWER
('New City', 'NLS_SORT = XFrench')
FROM DUAL;
Output
------
New City