Printable View
I am trying to get the script of view using all_views , text column. When I spool it in sqlplus, I am not able to get the
full text in the file.
Am I missing something.
Also, as the text is a long column , I am not able to do a
substr or any operation on that. I am sure there is a
round about way to do this.
Can somebody help me on this.
Im guessing its that you need to set the 'long' setting.
In sqlplus, try
set pagesize 1000
set long 1000000
try running the query again to get the text and let me know if that works. If not then I will have another think :-)
Hi bmycroft,
I was just wondering the same thing as ganesh when I came across this thread.
The solution you gave works a treat.
Many thanks
Allie.
Hi Bmycroft,
Ur suggestion worked great!
Is there a way to manipulate the long column ?
Many Thanks,
Ganesh.