DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: spool file

  1. #1
    Join Date
    Mar 2001
    Location
    south africa
    Posts
    401

    spool file

    Hi Guys,

    When i spool , I would like to add date and time stamp to the spool file.How do i do that?

    spool c:\AMquery_.log

    Pls help

    thanks

  2. #2
    Join Date
    Jan 2003
    Location
    Hull, UK
    Posts
    220
    column dcol new_value mydate noprint
    select to_char(sysdate,'YYYYMMDD') dcol
    from dual;

    spool &mydate._report.txt
    -- my report goes here
    select * from mytable;
    spool off

    HTH
    SS

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width