Madhava Reddy

• May 23rd, 2013

 

Code
 

lviswanath

 Profile Answers by lviswanath 

• Jul 18th, 2013

 

You can do by this way

Code
span style="font-style: italic;">--you can specify your own size


--specify same size as v_str

anandkiran

 Profile Answers by anandkiran 

• Sep 10th, 2013

 

Use simple decremented for loop with an variable

Code
span style="color: #ff0000;">"""test"

PANKAJ

• Jul 23rd, 2014

 

Code
#include<iostream>


#include<conio.h>


"pankaj"

harsh

• Sep 22nd, 2014

 

Answer:

Code
span style="font-style: italic;">--DBMS_OUTPUT.PUT_LINE(V_reverse);

killvinkill

 Profile Answers by killvinkill 

• Feb 3rd, 2015

 

DECLARE
input varchar2(30);
reverse varchar2(30);
n integer(3);
BEGIN
input:=&input;
for n in reverse 1..length(input) loop
reverse:=reverse||substr(input,n,1);
end loop;
dbms_output.put_line(reverse);
end;
/

Senthil

• Jul 9th, 2016

 

Code
 

vishalNair

 Profile Answers by vishalNair 

• Aug 15th, 2016

 

DECLARE
WORD VARCHAR(30):=ANUPAMA;
NEW_WORD VARCHAR(30);
X NUMBER(10) :=0;
BEGIN
X:=LENGTH(WORD);
FOR Y IN 0 ..X-1
LOOP
Z:=SUBSTR(WORD,X-Y,1) ;
NEW_WORD : = NEW_WORD||Z;
DBMS_OUTPUT.PUT_LINE(WORD IS ||NEW_WORD)
END LOOP;
END;

pradeep

• Nov 22nd, 2016

 

set serveroutput on
DECLARE
WORD VARCHAR(30):=ANUPAMA;
NEW_WORD VARCHAR(30);
X NUMBER(10) :=0;
BEGIN
X:=LENGTH(WORD);
FOR Y IN 0 ..X-1
LOOP
NEW_WORD :=SUBSTR(WORD,X-Y,1);
DBMS_OUTPUT.PUT_LINE(WORD IS ||NEW_WORD);
END LOOP;
END;

Hemanth

• Nov 26th, 2016

 

Code
 

Gyanaranjan Mishra

• Jan 9th, 2017

 

In a simpler way
--reverse a string
DECLARE
my_string VARCHAR2(100):=ODISHA;
new_string VARCHAR2(100);
BEGIN
FOR i IN REVERSE 1..Length(my_string)
LOOP
new_string:=new_string||SubStr(my_string,i,1);
-- Dbms_Output.put_line(new_string);
END LOOP;
Dbms_Output.put_line(new_string);
END;
/

Dhanyaa

• Jan 13th, 2017

 

SELECT REVERSE(WELCOME) FROM DUAL;

Tarika Bhutani

• May 25th, 2017

 

Code
 

Nani

• Jan 25th, 2018

 

Select listagg(substr(Nani,rownum,1)) within group(order by rownum des) as rev from tbl connect by level<=length(Nani); you can use column name instead Nani string char.

ushodaya

• May 20th, 2018

 

declare
str1 varchar2(50):=&str;
str2 varchar2(50);
len number;
i number;

begin
len:=length(str1);

for i in reverse 1..len
loop
str2:=str2 || substr(str1,i,1);
end loop;

dbms_output.put_line(Reverse of String is:||str2);
end;
/

Shivam Softa

• Sep 19th, 2018

 

SELECT LISTAGG(VAL) WITHIN GROUP(ORDER BY LE) FROM
(select LEVEL LE , substr(SHIVAM,-LEVEL,1) VAL FROM DUAL CONNECT BY LEVEL <= LENGTH(SHIVAM));