Home » SQL & PL/SQL » SQL & PL/SQL » Using UTL_FILE
Using UTL_FILE [message #227506] Wed, 28 March 2007 07:35 Go to next message
Messages: 13
Registered: January 2007
Junior Member

I have a procedure for follwing scenario

1)we get monthly records with five columns in a flat file(text) from different department.
2)we have to match the records with our database.If 100% matches then write these records in another flat file or else send to exception.

Anyone please help me on how to do this using UTL_FILE.

Thanks in Advance,
Have a great day.
Re: Using UTL_FILE [message #227532 is a reply to message #227506] Wed, 28 March 2007 08:42 Go to previous message
Messages: 1027
Registered: October 2006
Location: United Kingdom
Senior Member
Search for external table in oracle documentation.
Previous Topic: dimensions
Next Topic: working with delimited data in oracle
Goto Forum:

Current Time: Wed Aug 23 10:54:31 CDT 2017

Total time taken to generate the page: 0.02183 seconds