INSTR , SUBSTR 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 2009.12.11
DBMS_LOB select SELECT DBMS_LOB.SUBSTR (CONTENTS, DBMS_LOB.getlength (CONTENTS), 1) conts FROM TABLE_NAME WHERE SEQ = 1 lob타입의 데이터를 select 하는 방법이다. - write by 꼬마갱이 2009.12.11 - ORACLE·sql 2009.12.11