PL/SQL Cursor to Display Names in Uppercase

PL/SQL Cursor to Display Names in Uppercase:

declare
cursor upr is select upper(ename)ename from emp order by empno;
begin
for i in upr
loop
dbms_output.put_line(i.ename);
end loop;
end;

OUTPUT:

SMITH
ALLEN
WARD
JONES
MARTIN
BLAKE
CLARK
SCOTT
KING
TURNER
ADAMS
JAMES
FORD
MILLER

You may also like...

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.