-
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 spool first
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|