Substr And Instr

 Hi All,

In the below query is not displaying exact result,

select trim(substr('Person:1234 business group:xyz abc',

decode(instr( 'Person:1234 business group:xyz abc','business group:'),0,length('Person:1234 business group:xyz abc'),instr('Person:1234 business group:xyz abc','business group:'))+15

,decode(instr(substr('Person:1234 business group:xyz abc',

instr('Person:1234 business group:xyz abc','business group:')+15

,length('Person:1234 business group:xyz abc')

)

,' ')

,0

,length('Person:1234 business group:xyz abc')

,instr('Person:1234 business group:xyz abc','business group:')+15

,length('Person:1234 business group:xyz abc')

)

,' ')

)

)) from dual;

o/p : xyz

I am expecting o/p like xyz abc