insert values in text file to Oracle database

From: ngoc <linh_at_chello.no>
Date: Fri, 16 Jan 2004 05:54:54 +0100
Message-ID: <5HKNb.268$O41.874@amstwist00>

Hi
I have values in a text file for example;

A;100
B;200
C;300
D;400

.........

It is time consumming to type
insert into table values ('A',100);
insert into table values ('B',200);
....

Is there any mechanism in Oracle to insert automatically from a text file?

Thanks
Ngoc Received on Thu Jan 15 2004 - 22:54:54 CST