When running a SQL script, I got error ORU-10027 Buffer overflow,limit of 2000 byte. How to set a biger buffer, I tried
set buffer ??? , but did not work.
Another question is , how to use spool command to let the SQL output
going to a file.
Thanks
Printable View
When running a SQL script, I got error ORU-10027 Buffer overflow,limit of 2000 byte. How to set a biger buffer, I tried
set buffer ??? , but did not work.
Another question is , how to use spool command to let the SQL output
going to a file.
Thanks
I would suggest RTM first especially this one - Oracle Concepts
Hi,
Do u want to spool the data from table.
Just try the following steps.
1. select * from table name;
2. Go to File
3. Select Spool
4. Give a Spool file name
5. Just enter the /
6. GO to file
7. Select Spool
8. Select Spool off
9. It will save as LST file
10.Open the LST file in XL or Word.
That's all.