text file to Oracle
From: Herve Muyal <hmuyal_at_disun22.epfl.ch>
Date: 1996/01/11
Message-ID: <4d2p11$j1a_at_info.epfl.ch>#1/1
Date: 1996/01/11
Message-ID: <4d2p11$j1a_at_info.epfl.ch>#1/1
Hello,
I have a text file of this form:
Name=Tom
Phone=1269-3445
ZIP=12345
City=New York
------------------
Name=Jack
Phone=305-3445
ZIP=48901
City=Miami
------------------
Name=Laura
Phone=
ZIP=9012
City=Los Angeles
------------------
I have created a table with all those fields.
Is it possible to run a command (or a small script) to enter
all the data (actually only the stuff written after "=")
(INSERT INTO table......) for the entire file???
Thank you in advance...