Home » SQL & PL/SQL » SQL & PL/SQL » reverse
reverse [message #39613] Fri, 26 July 2002 06:33 Go to next message
anjaneya
Messages: 1
Registered: July 2002
Junior Member
1. how to print the data in reverse order?
Re: reverse [message #39614 is a reply to message #39613] Fri, 26 July 2002 07:11 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
SQL> ed
Wrote file afiedt.buf

  1  declare
  2  a varchar2(10):='forward';
  3  o varchar2(10);
  4  b varchar2(10);
  5  begin
  6  for mag in reverse 1..length(a) loop
  7   b:=substr(a,mag,1);
  8   o:=O||b;
  9   end loop;
 10  dbms_output.put_line(o);
 11* end;
SQL> /
drawrof

PL/SQL procedure successfully completed.

Previous Topic: How to view a stored procedure definition in Oracle
Next Topic: SysDate
Goto Forum:
  


Current Time: Thu Apr 25 19:10:37 CDT 2024