How to update Oracle table with CSV file

1149570 pts.
Tags:
CSV file
Oracle
My CSV file has several columns. Now in my Oracle table, the ID automatically identifies a row. Is there for me to replace my values in that table with the CSV file values while keeping everything else the same? Would a SQL script work?
1

Answer Wiki

Thanks. We'll let you know when a new response is added.

In my experience no, and the only way to import data is through dump files or a script of type Update or Insert, previously generated for example with TOAD. Anyway there are several applications that can do that perfectly, I use the OraDump Export Kit (Intelligent Converters) that allows both export and import data, in different formats besides CSV.


Hope it help
Claudio

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • carlosdl
    What does "the ID automatically identifies a row"?

    One thing is to identify a row, which a primary key always does, but another thing is that the columns is "generated" automatically.

    If you are talking about the second option, how is it generated? By a trigger?

    What database version are you using? In 12c there are more ways to automatically generate IDs, so, it really depends on how that was designed and the database version being used.

    To give a more concrete answer, more details are needed, including an exact example of what you want to do.
    85,025 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: