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 -
'ORACLE·sql' 카테고리의 다른 글
| [펌]오라클 ORDER BY DECODE(..정렬을 내마음대로) (0) | 2009.12.23 |
|---|---|
| temp Long (0) | 2009.12.11 |
| DBMS_LOB select (0) | 2009.12.11 |
| LPAD, RPAD (0) | 2009.12.11 |
| sysdate (0) | 2009.12.11 |