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
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
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment