Thread: sql
View Single Post

  #4 (permalink)  
Old 12-15-2006, 07:00 AM
neelu.payola neelu.payola is offline
Junior Member
  
Join Date: Dec 2006
Posts: 3
neelu.payola is on a distinguished road
SQL> select emp_id,substr(emp_name, instr(emp_name,' '))||' '||
substr(emp_name,0,instr(emp_name,' ')) from emp1;
Reply With Quote