Series: Subject: Topic:

Question: 5 of 291

Reverse a string in Oracle without using reverse

How do I reverse a dtring in Oracle without using PL/SQl and without using the reverse function??

Asked by: amit88 | Member Since Apr-2012 | Asked on: Apr 5th, 2012

View all questions by amit88

Return back to Oracle

Answer Question

Showing Answers 1 - 1 of 1 Answers

Mark Haynes

Answered On : Apr 13th, 2012

View all questions by Mark Haynes View all answers by Mark Haynes

Are you looking for something like this?


Code
FUNCTION revstring(instring VARCHAR2) RETURN VARCHAR2 IS
  rstring VARCHAR2(750) := ;
  iCnt    PLS_INTEGER;
BEGIN
  FOR icnt IN REVERSE 1..LENGTH(istring) LOOP
    BEGIN
      rstring := rstring ||  SUBSTR(istring, icnt, 1);
    END;
  END LOOP;
  RETURN rstring;
END;

Answer Question

1 User has rated as useful.

User Panel

Lost Password

Get Activation Code

Interview Coaching

What will you do when you are not able to get your message across to your audience?

What are the career options available in Software Testing Industry?

What do you do when things do not go as planned? Cite an example.

Tell me three things about you, which are not found in your resume

Do you have any questions that you want to ask?

How to handle academic gap while applying for a job?

Provide an example of a goal that you successfully attained.

What do you think about our company?

How do you handle pressure and stress?

Career Options for BCA Graduates

Connect

Question Categories

Oracle DBA FAQ

Interview Question

Latest Questions

Interview & Career Tips

Get invaluable Interview and Career Tips delivered directly to your inbox. Get your news alert set up today, Once you confirm your Email subscription, you will be able to download Job Inteview Questions Ebook . Please contact me if you there is any issue with the download.

Reverse a string in Oracle without using reverse

Give your answer:

Related Answered Questions

Related Open Questions