Re: loading tools (followup)

[Quoted] With that in mind, I know there is a REPLACE option with SQL*Loader, but I [Quoted] think that does a TRUNCATE on the table first prior to inserting the rows. [Quoted] That would not be a good thing. I think the other option is the APPEND to [Quoted] add stuff on the end. I haven't used it in quite a while, so I haven't read [Quoted] any documentation on it lately.

[Quoted] Can you tell me which version you are using and on what platform? I can look it up tomorrow and see if we might be missing something...

If it does NOT have the option we are looking for, why not just load it into [Quoted] [Quoted] ANOTHER table (a temporary table), then write a pl/sql routine that loads it [Quoted] into the real table and does the inserts or updates depending on the keys. [Quoted] You could add MORE validation to that and produce a report with either DBMS_OUTPUT OR UTL_FILE. For things like this, I usually write PRO*cobol [Quoted] load routines, but I'm from a VAX/VMS background...

"Egon" <egonvdb_at_xs4all.nl> wrote in message news:8v0l9h$g74$1_at_news1.xs4all.nl...
> Is there a tool available to load ASCII data into tables and if a
> record(key) exists
> update that record.
>
>
Received on Fri Nov 17 2000 - 01:45:20 CET