Re: What's the Best Practice To Synchronize A Table With External Data?

Gad krosner wrote:

> Hi There!
>
> I have a table with data. For simplification, let's say it has two
> columns, Code char (1), and Description char (40).
>
> I now get a spreadsheet with update. It contains both the code and
> the description. My task is to update the description whenever I find
> the code in both table and file, and insert any new pair of
> code/decode I encounter in the input.
>
> What's the best tool/method to accomplish this?
>
> Thanks,
>
> G.

My suspicion here is that you are a student trying to get someone to do your homework for you. Firstly because no one would define a description column as CHAR(40) and secondly because this is extraordinarily basic and you appear to have done absolutely no work to help yourself with the problem.

My suggestion, unless you can convince me otherwise, is to read your textbook.

Alternatively my suggestion would be to write a routine using the UTL_FILE built-in package or SQL*Loader.

Daniel Morgan Received on Mon Sep 23 2002 - 16:50:12 CDT