Convert To Lowercase in Oracle

If you want to convert some value to Lowercase while Select/Insert/Update/Delete operation in Oracle, then you can use lower() function in Oracle.

Example:

select EmpID, lower(Emp_Name) from tblEmployee;
insert into tblEmployee (EmpID, Emp_Name) values (100, lower('Banshi'));
update tblEmployee set Emp_Name=lower('Banshi') where Emp_Name='Banshi'
delete from tblEmployee where lower(Emp_Name)='banshi'

You can use lower() function in any query, function or procedure.

Read about upper() function in Oracle.

0 comments:

Post a Comment

top