Mahmoud Al Jundi
asked on
SQL Loader
Hello
What is correct Control File structure to use with SQL Loader in order to import the following CSV file into Oracle 8.1 as below example :
CSV File :
"600X",100.3,"FILTER","16/ 06/1995"
TABLE STRUCTRE :
PART_NUMBER VARHCAR2(50)
PRICE NUMBER (24,2)
PART_NAME VARHCAR2(50)
BORN_DATE DATE
What is correct Control File structure to use with SQL Loader in order to import the following CSV file into Oracle 8.1 as below example :
CSV File :
"600X",100.3,"FILTER","16/
TABLE STRUCTRE :
PART_NUMBER VARHCAR2(50)
PRICE NUMBER (24,2)
PART_NAME VARHCAR2(50)
BORN_DATE DATE
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER