- 使用dbms_lob.read
CREATE OR REPLACE FUNCTION getclob(lobloc CLOB) RETURN VARCHAR2 IS
buffer VARCHAR2(32767);
amount NUMBER := 4000;
offset NUMBER := 1;
BEGIN
dbms_lob.read(lobloc, amount, offset, buffer);
RETURN buffer;
EXCEPTION
WHEN no_data_found THEN
RETURN buffer;
END;
- dbms_lob.substr
SELECT dbms_lob.substr(xxx) FROM XXX;