BLOB관련

[BLOB으로 변환하기]

SELECT UTL_RAW.CAST_TO_RAW( SOME_TEXT )

    FROM S_DUAL;

 

 

 

[BLOB 조회하기]

SELECT UTL_RAW.CAST_TO_VARCHAR2(DBMS_LOB.SUBSTR(BLOB_COLUMN, 4000,1))
  FROM SOME_TABLE;