Hi fellow developers,
How do I spool my query with the results of it?
I am able to spool data only but I need to see the query I am using as well.
There should be a command for it.. at least I hope there is...
Printable View
Hi fellow developers,
How do I spool my query with the results of it?
I am able to spool data only but I need to see the query I am using as well.
There should be a command for it.. at least I hope there is...
Type the spool command first and then the sql query. This will display the query and then the results.
When you run the spool file or any command,
set echo on
This will display the queries as well.
Thanks
set echo on
spool (file name you need)
select ___
from ____
where ____
spool off
now, look for the file