friends,
any possibilities to do such thing in sql script?
trying to have dynamic spool file name during sql script run....
currently I have hard coded spool name but it's really inconvenient for user to edit sql everytime and change file name....
requires filename something like below..
e.g. spool $dbname_$dbuser_$dttime.log
user who is running doesn't have admin access.
test.sql
spool t1.log
set echo off
set termout off
select * from user.employees;
spool off;