[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