Re: How to load ascii file in oracle table

From: Ban Spam <ban-spam_at_operamail.com>
Date: Fri, 26 Oct 2001 00:42:51 GMT
Message-ID: <Xns9145B437E7F5FSunnySD@24.0.3.73>

daniel.st-jacques_at_ca.kontron.com (Daniel St-Jacques) wrote in news:2355c0e9.0110250942.36963614_at_posting.google.com:

> Hello all
>
> I am new in the Oracle / SQL world.
>
> I need help.
>
> Here is my problem.
>
> I need to create a program that will load an ASCII file into an Orcale
> Table.
>
> ASCII FILE: file.txt
> Contents: 123,Joe Blow,123 lost,somewhere,nowhere
> 124,Mary Jains,324 where,city,country
>
> Oracle Table: CUST-NUM
> NAME
> ADDRESS
> CITY
> ZIP
> COUNTRY
>
> I need to do an SQL program that will check if the customer exist.
> If it exist, the program has to update the oracle table with the
> information from the ascii file.
> If it is not exist, the program has to create the customer into the
> oracle table.
>
> Is someone can help me PLEASE.
>
> Thank you
>
> You can send my your suggestion at
> daniel.st-jacques_at_ca.kontron.com
> or
> stjacqd_at_hotmail.com
>
> Thank you again
>

SQLLDR utility supplied by Oracle will load your data. Load it into a TEMP/WORK table & then use SQL to INSERT the new records.

What happens when the names match but the rest of the fields are different? Received on Thu Oct 25 2001 - 19:42:51 CDT