|
|
|
|
Re: HOW TO SPOOL CLOB DATA INTO FLAT FILE [message #526626 is a reply to message #526623] |
Wed, 12 October 2011 01:23 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
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
|
|
|
|
|