PL/SQL Cursor to Display Names in Lowercase

PL/SQL Cursor to Display Names in Lowercase:

declare
cursor lowwer is select lower(ename)ename from emp order by empno;
begin
for i in lowwer
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.