Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> sqlplus set lob return length?
I am trying to use dbms_metadata.get_ddl, but the ddl returned is too long and is getting truncated in sqlplus. I went to the sqlplus doc and the only set command I could find for lobs is lobof which sets the offset. That doesn't look like what Ineed.
Is there sqlplus command to allow to return more data from a clob to sqlplus?
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Jun 07 2006 - 10:14:06 CDT
![]() |
![]() |