469,125 Members | 1,271 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,125 developers. It's quick & easy.

spool use

what is the use of SPOOL COMMAND
Dec 31 '06 #1
2 10207
spool is a way to record the output of the activity done after the spool command
It generates a file which shows the activities and their results
Jan 4 '07 #2
There are various uses of the spool command. You can spool out to a file , then use normal SQL to get small reports with some formatting. For example
SQL> Spool /ora/spool.txt
SQL> select "List of employees drawing more than Rs 10000" from dual;
SQL> select EmpNo,Name from Emp where Salary > 10000;
SQL> spool off;

vi the spool.txt file and delete the "select" lines and hey ! u have a report ready.

A more practical use will be during database development when u are piping in a large amount of data and you need to disable some triggers. Experiment !!!
Jan 10 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

1 post views Thread by Mario Horvat | last post: by
1 post views Thread by david_0 | last post: by
reply views Thread by prithvis.mohanty | last post: by
reply views Thread by prithvis.mohanty | last post: by
reply views Thread by Robert | last post: by
1 post views Thread by orajit | last post: by
1 post views Thread by akaley | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.