Instr And Substr

 HI All,

I need one query.please see below my sql statement

select trim(SUBSTR('Empno:1234 Empname:Rama jay' trim(SUBSTR('Empno:1234 Empname:Rama jay' ,DECODE(INSTR('Empno:1234 Empname:Rama jay', 'Empname:'),0,LENGTH('Empno:1234 Empname:Rama jay'),INSTR('Empno:1234 Empname:Rama jay', 'Empname:')) + 8 ,DECODE(INSTR('Empno:1234 Empname:Rama jay', 'Empname:'),0,LENGTH('Empno:1234 Empname:Rama jay'),INSTR('Empno:1234 Empname:Rama jay', 'Empname:')) + 8 ,DECODE(INSTR(SUBSTR('Empno:1234 Empname:Rama jay' ,DECODE(INSTR(SUBSTR('Empno:1234 Empname:Rama jay' ,INSTR('Empno:1234 Empname:Rama jay', 'Empname:') + 8 ,INSTR('Empno:1234 Empname:Rama jay', 'Empname:') + 8 ,LENGTH('Empno:1234 Empname:Rama jay') ,LENGTH('Empno:1234 Empname:Rama jay'