Hi All,
I have oracle 10G R2 On windows.
I have 5 queries. I need time taken by each query to execute after 15 min interval, for that i am planning to use spool command in a batch file
Like i will create a batch file and get the connection from batch file and execture .sql file from batch file. .sql file will hold all the below mention queries.
But issue is spool command will overide the existing spool file since the query will run after 15 minuts interal.
What I am doing
set serveroutput on
set time on timing on
spool c:\chanchal
select * from employee;
select * From dept;
select * from test;
select * From test_1;
select * from test_2;
set time off timing off
spool off;
can we get differenct name for each spool file.