SQL Spool Function - Prompt for location
Discussion
Folks,
I'm writing an sql script to count the number of records in a database so users can run the script before and after upgrades to prove that all the tables are still intact.
Obviously, these need to be spooled, but i'm having trouble figuring out how you "prompt" the user to enter a file name. So far i'm doing this:
spool c:\blah\test.txt
set echo on
several count statments
set echo off
spool off
Inplace of c:\test.txt above, is there any way in which i can force the user to enter a location themselves? The reason being is they don't have access to the the "blah" folder, or their default oracle directory...
I'm writing an sql script to count the number of records in a database so users can run the script before and after upgrades to prove that all the tables are still intact.
Obviously, these need to be spooled, but i'm having trouble figuring out how you "prompt" the user to enter a file name. So far i'm doing this:
spool c:\blah\test.txt
set echo on
several count statments
set echo off
spool off
Inplace of c:\test.txt above, is there any way in which i can force the user to enter a location themselves? The reason being is they don't have access to the the "blah" folder, or their default oracle directory...
Gassing Station | Computers, Gadgets & Stuff | Top of Page | What's New | My Stuff