Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Bulk insert into table from text file

996280Jun 19 2013 — edited Oct 24 2013

Table :

SQL> desc ZIP_FILE

Name                                      Null?    Type

----------------------------------------- -------- ----------------------------

COUNTRY_CODE             NOT NULL VARCHAR2(2 CHAR)

ZIP_CODE                        NOT NULL VARCHAR2(20 CHAR)

LAT                                  NOT NULL NUMBER(9,6)

LON                                 NOT NULL NUMBER(9,6)

File:

File Content file ZIP.txt

US 00601-66.74996118.180555
US00602-67.17613018.362268
US00603-67.11988718.455183
US00606-66.93291118.158345

Now please help me how I can upload this file into table ZIP_FILE.  like BULK INSERT in SQLServer.

Oracle Version --11.2.0.1.0 - 64bit

I am unable to do sqlldr. Could you please help me to same in procedure

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 21 2013
Added on Jun 19 2013
9 comments
6,745 views