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

Leave a Reply

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

13 − 8 =