User Questions - GeekInterview.com

Home

Submitted Questions

Reverse a string in Oracle without using reverse

Asked By: amit88 | Asked On: Apr 5th, 2012

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

Answered by: Mark Haynes on: Apr 13th, 2012

Are you looking for something like this?"plsql function revstring(instring varchar2) return varchar2 is rstring varchar2(750) := ; iCnt pls_integer; begin for icnt in reve...

Reversing string in Oracle without using reverse function

Asked By: amit88 | Asked On: Apr 5th, 2012

1 answer

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

Answered by: Siva Kumar S on: Apr 7th, 2012

I just took employees tables last_name. See the code.


Code
SELECT substr(last_name,4,1)||substr(last_name,4,2)||substr(last_name,2,1)||substr(last_name,1,1) 
"Reversing Name" FROM employees
WHERE employee_id=100

User Panel

Lost Password

Get Activation Code

Interview Coaching

What is the role of a mechanical engineer in the Software Industry?

What do you do when someone criticizes you?

Describe a time when you had to work under pressure.

Has anyone asked you for help? What did you do?

Describe a time when you had to convince a friend ?

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

What do you think about our company?

Have you gone above and beyond your job description?

How do you approach a problem?

What is your way of building rapport with a person you just met?

User Panel

Categories

Interview Coaching

Interview Question

Career Counselling

GeekInterview

Popular Sections