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

Thread: File naming with utl_file !

  1. #1
    Join Date
    Jul 2003
    Posts
    323

    File naming with utl_file !

    I have to append the date to a file generated with ult_file. Can someone give a few tips as to how to do this. The way I see it is to

    select sysdate into var from dual;

    var:= 26-SEP-05 (is now today's date)

    How to get the filename as : filename26SEP05 or filename260905 ?

    Thanks in advance !


  2. #2
    Join Date
    Nov 2001
    Location
    UK
    Posts
    152
    Something like:

    filename := filename||to_char(sysdate, 'DDMMYY');

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