|
|
|
|
Re: HOW TO SPOOL CLOB DATA INTO FLAT FILE [message #526626 is a reply to message #526623] |
Wed, 12 October 2011 01:23 |
|
Michel Cadot
Messages: 68665 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
set linesize 32767 long 32767 longchunksize 32767 trimout on trimspool on
Of course if your CVLOB is larger than 32K then you can't get it in a single line.
can i spool it in excel..??
Not more but you can pull it from Excel using VBA and ODBC (for instance).
Regards
Michel
[Edit: missing letter]
[Updated on: Wed, 12 October 2011 01:53] Report message to a moderator
|
|
|
|
|