Sunday, August 15, 2010

Oracle 11g: Case-Manipulation Sample

select ('peAhShAn') from dual;
select lower('peAhShAn') from dual;
select upper('peAhShAn') from dual;
select Initcap('peAhShAn') from dual;

Results:

('PEAHSHAN')
------------
peAhShAn    


LOWER('PEAHSHAN')
-----------------
peahshan         


UPPER('PEAHSHAN')
-----------------
PEAHSHAN         


INITCAP('PEAHSHAN')
-------------------
Peahshan           

No comments: