ORACLE·sql

INSTR , SUBSTR

administrators 2009. 12. 11. 15:58

SELECT
     SUBSTR( 'EX_CONTENTS', 4) SUBSTR1
    ,INSTR ('EX_CONTENTS', '_') INSTR1
    ,SUBSTR( 'EX_CONTENTS', INSTR ('EX_CONTENTS', '_') ) SUBSTR2
    ,SUBSTR( 'EX_CONTENTS', INSTR ('EX_CONTENTS', '_') + 1 ) SUBSTR3
FROM DUAL

 

- write by 꼬마갱이 2009.12.11 -