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 -