DataBase > Oracle/Tibero

CLOB 데이터 툴에서 확인

dbms_lob.substr(컬럼명, 길이, offset) 사용

select dbms_lob.substr(clob_column, 2000, 1) from my_table;

select dbms_lob.substr(clob_column,  dbms_lob.getlength(clob_column), 1) from my_table;