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.749961 | 18.180555 |
US | 00602 | -67.176130 | 18.362268 |
US | 00603 | -67.119887 | 18.455183 |
US | 00606 | -66.932911 | 18.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