The Moto behind for Creating this Blog is to share the concepts Of Oracle Database.In This Blog,The Information is gathered from Metalink,Expert's Blog and Oracle Documentaion.It Includes Real Time Scenarios,Oracle9i concepts,Oracle10g Concepts,RAC,Streams,Replication...
Please do visit my blog and post your comments & advice please.
Tuesday, October 9, 2007
How do I Put current Date in a spool file name?
column dcol new_value mydate noprint select to_char(sysdate,'YYYYMMDD') dcol from dual;