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