How to load ascii file in oracle table

From: Daniel St-Jacques <daniel.st-jacques_at_ca.kontron.com>
Date: 25 Oct 2001 10:42:40 -0700
Message-ID: <2355c0e9.0110250942.36963614@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 Received on Thu Oct 25 2001 - 12:42:40 CDT