Hi Albert,. You can use DBMS_LOB.substr like this for example: [code]DBMS_LOB.substr(column, 3000)[/code]. but don't forget that substring of a CLOB column ...
確定! 回上一頁