PL/SQL Procedure to Convert String in Uppercase and Lowercase

PL/SQL Procedure to Convert String in Uppercase and Lowercase:

create or replace procedure u_l(s1 in varchar,s2 in varchar) is
str1 varchar(15);
str2 varchar(15);
begin
select upper(s1) into str1 from dual;
select lower(s2) into str2 from dual;
dbms_output.put_line('Uppercase '||str1);
dbms_output.put_line('Lowercase '||str2);
end;

Calling Procedure:

begin
u_l('upper','LOWER');
end;

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.