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
kavi123
Messages: 13
Registered: January 2007
Junior Member
Hi,

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
S.Rajaram
Messages: 1027
Registered: October 2006
Location: United Kingdom
Senior Member
Search for external table in oracle documentation.
Previous Topic: working with delimited data in oracle
Next Topic: Deleting duplicate records from oracle object
Goto Forum:
  


Current Time: Fri Dec 02 20:38:13 CST 2016

Total time taken to generate the page: 0.12687 seconds