Re: insert values in text file to Oracle database

From: Jim Kennedy <kennedy-downwithspammersfamily_at_attbi.net>
Date: Fri, 16 Jan 2004 05:35:44 GMT
Message-ID: <QKKNb.77548$8H.114312@attbi_s03>

"ngoc" <linh_at_chello.no> wrote in message news:5HKNb.268$O41.874_at_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
>

Yes, and much faster. Look in the documentation for SQLLoader. Also in 9i you can use an external table. Jim Received on Thu Jan 15 2004 - 23:35:44 CST