-
Reading Flat Files from Oracle PL/SQL
Hi,
Every 3 days I got Flat Files as a Source. What I have to do is, read that Flat File and insert into Database Tables. While inserting into that tables, may be update/Delete the Front end Application at the same time.
Could any one help me the best solution for this.
Thanks in Advance,
SankarG
-
Jurij Modic
ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?
-
Search the Ask Tom website for UTL_FILE. There are some great examples on there.
-
I'm stmontgo and I approve of this message
-
use external table if you have 9i
-
What factors will determine which approach to take for uploading a text file, i.e.,
- UTL_FILE package or
- External table/SQL Loader
Cheers!
OraKid.
-
If you are not changing the source file, then use SQL Loader, this is very fast.
Or UTL_FILE or external table will help.
If you are using 9i, then try PIPELINE fn. The real advantage of PIPELINE is it does not wait to fetch all the rows. As soon as it reads some rows, it will pass on to the calling routine.
Tamil
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
|