Need Shell Script to Pass Variables in Oracle
Posted on 2005-04-04
Hi Experts ,
I am looking for a script which will run a sqlplus command i,e
select owner,object_name,object_type from dba_objects where trunc(LAST_DDL_TIME) >= trunc(sysdate)-1;
which will spool into a spool file of format ddmonyyyy.txt . Every day this is spooled and a new file would be generated which would be identified by date. Can any one tell me how to do this .