-
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]
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|