Code with substr and instr in oracle apps r12
select SUBSTR('XLOGIC HIBM-CHI',9,INSTR('XLOGIC HIBM-CHI','-',1)-9) from dual;
Value returns as IBM
select SUBSTR('XLOGIC HIBM-CHI',9,INSTR('XLOGIC HIBM-CHI','-',1)-9) from dual;
Value returns as IBM
No comments:
Post a Comment