如何查询Oracle中的CLOB列(How to query a CLOB column in Oracle)

 我试图运行一个具有CLOB数据类型的几列的查询。 如果我像正常一样运行查询，那么所有这些字段都只有(CLOB)作为值。 
 
 我尝试使用DBMS_LOB.substr(column ），我得到的错误 
 
ORA-06502: PL/SQL: numeric or value error: character string buffer too small
 
 我如何查询CLOB列？ 

I'm trying to run a query that has a few columns that are a CLOB datatype. If i run the query like normal, all of those fields just have (CLOB) as the value.
 
I tried using DBMS_LOB.substr(column) and i get the error 
 
ORA-06502: PL/SQL: numeric or value error: character string buffer too small
 
How can i query the CLOB column?

原文：https://stackoverflow.com/questions/3790379