I want to have a file name with month and day as suffic . can anyone help?
Could you please provide additional information, and rephrase your question? What file?
UTL_FILE.FOPEN(directory path','File Name'||to_char(sysdate,'dd/mm/yyyy_Day')||'.txt','W');
You can use this if you want to create a file from a database stored procedure.
Hope this will help u ?
i want to name a file which is develoed daily as a flat file
[Edited by joe_kk on 05-04-2001 at 08:35 AM]
Click Here to Expand Forum to Full Width