PL/SQL Procedure To Reverse A String

Use the following PL/SQL Procedure to reverse a string

create or replace procedure rev(x in varchar2) as
c char(1);
i number;
begin

for i in 1..length(x) loop
select substr(x,length(x)-i+1,1) into c from dual;
dbms_output.put(c);
end loop;
dbms_output.put_line(' ');
end;
/

SQL> set serverout on
SQL> exec rev('Java')

Output: avaJ 


Other Most Useful PLSQL Scripts:

1. PL/SQL Function To Compute The Factorial Of A Number
2. PL/SQL Function To Convert A Binary Number To A Decimal Number
3. PL/SQL Function To Convert A Decimal Number To A Binary Number
4. PL/SQL Function To Convert Ruppies(Numbers) In Words
5. PL/SQL Function To Generate The Fibonacci Series
6. PL/SQL Procedure For Counting All Tables And Respective Rows From Database
7. PL/SQL Procedure To Display Monthly Calender
8. PL/SQL Script To Calculate Weekdays Between Two Given Dates