Convert To Uppercase in Oracle

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

Example:

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

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

Read about lower() function in Oracle.
For more tips and tricks on Oracle, click here.