PL/Sql code for a text file

[meridian99]

I'm looking for some example code in Oracle Pl/sql language using oracle 7.34 that manipulates a text file to;

- create an empty text file and name it with todays date (20020102.dat)
- code to open it and append data as records
- code to close the text file

I'm new to PL/Sql programming....
thanks !

 

[rcurva]

You can can check out the UTL_FILE built-in package for this. Robbie

"The rule is, not to besiege walled cities if it can possibly be avoided" -- Art of War

 

[THoey]

Sounds like a lot of work when you can just do the following:

SPOOL 20020102.dat

SELECT *
FROM MyTable
WHERE CheckDate = '02-JAN-02';

SPOOL OFF

If you are wanting to automate this, you may need to use the UTL_FILE package, but I would think you could build a variable (&) and then use that variable for the filename and in the WHERE clause (&&).

Hope that helps... "Alcohol is our friend, and it's about time we had more friends over."

Terry M. Hoey