UTL_FILE question

From: Viktor <stant_98_at_yahoo.com>
Date: Fri, 30 Jan 2004 16:24:25 -0800
Message-ID: <F001.005DE782.20040130162425@fatcity.com>

Hello,

I have a procedure that open a cursor and dumps some data for last 24 months to a file. The date range is static condition defined inside the cursor. Procedure is working great, but I what I'm having problem figuring out is if there is a way to create not one file with all the data, but multiple files with monthly sets of data. This way data for month1 is created as <filename_012002.txt> and so forth. 

Thanks much!

Viktor

 

---

Do you Yahoo!?
Yahoo! SiteBuilder - Free web site building tool. Try it!

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Viktor
  INET: stant_98_at_yahoo.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Fri Jan 30 2004 - 18:24:25 CST