SELECT clob_column
FROM your_table
WHERE condition;
SELECT DBMS_LOB.SUBSTR(clob_column, length, offset)
FROM your_table
WHERE condition;
SELECT TO_LOB(clob_column)
FROM your_table
WHERE condition;
DECLARE
clob_data CLOB;
BEGIN
SELECT clob_column
INTO clob_data
FROM your_table
WHERE condition;
DBMS_OUTPUT.PUT_LINE(clob_data);
END;
需要注意的是，对于大型CLOB数据，最好使用DBMS_LOB包中的函数进行查询，以避免性能问题。
