Reversing String in Oracle without using reverse function

How do I reverse a string using only Oracle SQL without using the reverse function??

Questions by amit88

Showing Answers 1 - 4 of 4 Answers

Siva Kumar S

  • Apr 7th, 2012
 

I just took employees tables last_name. See the code.


Code
  1. SELECT substr(last_name,4,1)||substr(last_name,4,2)||substr(last_name,2,1)||substr(last_name,1,1) 

    2. 

  2. "Reversing Name" FROM employees

    3. 

  3. WHERE employee_id=100

  Was this answer useful?  Yes

rishitha

  • Jan 4th, 2022
 

then how can we make this into the loop to retrive for N no.of observations

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions