File naming with utl_file ! Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: File naming with utl_file !

  1. #1
    Join Date
    Jul 2003

    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
    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