How should I use SQL loader to load a .csv file as an Oracle Database ?
CREATE TABLE products( ProductID INTEGER NOT NULL, ProductName CHAR(30) NOT NULL, SupplierID INTEGER, CategoryID INTEGER, QuantityPerUnit CHAR(30) NOT NULL, UnitPrice INTEGER NOT NULL, UnitsInStock INTEGER NOT NULL, UnitsOnOrder INTEGER NOT NULL, ReorderLevel INTEGER NOT NULL, Discontinued CHAR(6) NOT NULL );
This was the table!
load data infile 'c:\Users\Animesh Pandey\product.csv' into table products fields terminated by "," optionally enclosed by '"' ( ProductID, ProductName, SupplierID, CategoryID, QuantityPerUnit, UnitPrice, UnitsInStock, UnitsOnOrder, ReorderLevel, Discontinued );
I saved this as load.ctl.
How should I run it?
I searched on the internet but that could not help.
Could any one help me with this problem?
PS: The .csv file is attached.