Update table from Flat file

[sanjeevpandey]

Hi all,

I want to UPDATE table from flat file. source is flat file and target is oracle table thru sql(PL/SQL)

Thanks

[debasisdas]

try using the utility tool SQL LOADER.

[lovellben]

Hi,

Create 'Temp Table' and Load records from FlatFiles to this/these table using the SQL*Loader and then use the UPDATE statement from PL/SQL...if that's what you want..

Else you might want to look in to direct loading...using the 'directory' method..

[jsmithstl]

I would:

1. create an oracle directory.
2. put your flat file in that directory.
3. create an external table using the flat file.
4. use a MERGE INTO statement to update the table.

MERGE INTO allows you to update a row if it exists or insert the row if it doesn't. As of 10g, you can even delete rows using MERGE INTO.