Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> How to load ascii file in oracle table
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
![]() |
![]() |