| External Table problem [message #72794] |
Tue, 21 October 2003 09:05 |
Chneih
Messages: 1
Registered: October 2003
|
Junior Member |
|
|
Hi,
I would appreciate any suggestions regarding my problem.
I have a CSV file to load, using an external table.
Here's an exmaple of the content...
123,"M",23,45,"SCHMIDT, JOE","MECHANIC",5
231,"F",45,68,"VALERIE","",7
456,"M",23,98,"","",9
How do I load this to a 7 column external table without any reject?
TABLE: PERS_TABLE
Rec_No NUMBER,
Gender CHAR(1),
Age NUMBER,
CC_Num NUMBER,
Name VARCHAR2(50),
Title VARCHAR2(50),
No_of_cars NUMBER
Thanks,
Chneih
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
