select dbms_lob.substr(column_name,字符长度) from table_name;
例:
select dbms_lob.substr(JOB_DATA,2000) from QRTZ_JOB_DETAILS;
select dbms_lob.substr(column_name,字符长度) from table_name;
例:
select dbms_lob.substr(JOB_DATA,2000) from QRTZ_JOB_DETAILS;