sql

[sriharid]

hai
can any one tell this query
having the table emp
emp_id emp_name
01 john paul
02 ravi kumar
03 hari babu

when retriving the record i want the query output of emp_name is

paul john
kumar ravi
babu hari

if any one knows this please reply me

[sarunraj]

hi,

select substr(emp_name,instr(emp_name,' ',2,1),length(emp_name))
||' '|| substr(emp_name,1,instr(emp_name,' ',2,1)) name1
from emp

i think this query will do it for you..

hope it helps,

regards
Raj

[cyrus]

sriharid did you try sarunraj suggestion. he haas given a good suggestion.You should get the output. Let us know the result.

[neelu.payola]

SQL> select emp_id,substr(emp_name, instr(emp_name,' '))||' '||
substr(emp_name,0,instr(emp_name,' ')) from emp1;