[DB] 오라클CLOB데이터 읽기
가끔 한번 써서 그런가 안 외워져서 적어둔다. 개쌔리야... SELECT * FROM ( SELECT DBMS_LOB.SUBSTR(FILE_STRE_COURS, DBMS_LOB.GETLENGTH(FILE_STRE_COURS), 1) AS LOB_CONTENTS FROM TN_FILEDETAIL ) A GROUP BY LOB_CONTENTS ; SELECT ATCH_FILE_ID, FILE_SN, DBMS_LOB.SUBSTR(FILE_STRE_COURS, DBMS_LOB.GETLENGTH(FILE_STRE_COURS), 1) AS FILE_STRE_COURS, STRE_FILE_NM, ORIGNL_FILE_NM, FILE_EXTSN, FILE_CN, FILE_SIZE FROM TN_FILEDETAIL
2022. 6. 8.