REVERSING A GIVEN STRING

AIM:
   To reverse a string in SQL.

ALGORITHM:
Get the input string.
Find the length of the string.
Extract the char one by one from the end of the string.
Concatenate the extract character.
Display the concatenated reverse string.
Stop the program.

PROGRAM:
SQL> set serveroutput on
SQL> declare
2 b varchar2(10):='&b';
3 c varchar2(10);
4 l number(2);
5 i number(2);
6 g number(2);
7 d varchar2(10);
8 begin
9 l:=length(b);
10 g:=l;
11 for i in 1..l
12 loop
13 c:=substr(b,g,1);
14 g:=g-1;
15 d:=dc;
16 end loop;
17 dbms_output.put_line('reversed string is');
18 dbms_output.put_line(d);
19 end;
20 /
Previous
Next Post »

If you still didn't find what you're looking for, you can search this website below: