create table temporary_orders
(
OrderId number,
OrderDate Date,
RequiredDate date,
ShippedDate date,
Shipvia number,
Freight number,
ShipName varchar(40),
ShipAddress varchar(60),
Shipcity varchar(15),
ShipRegion varchar(15),
ShipPostalCode varchar(10),
ShipCountry varchar(15),
LastName varchar(20),
FirstName varchar(10),
Title varchar(30),
TitleOfCourtesy varchar(25),
BirthDate date,
HireDate date,
EmpAddress varchar(60),
EmpCity varchar(15),
EmpRegion varchar(15),
EmpPostalcode varchar(10),
EmpCountry varchar(15),
Homephone varchar(24),
Extension varchar(5),
Photo varchar(100),
Notes varchar(100),
ReportsTo number,
CustomerID varchar(5),
CompanyName varchar(40),
ContactName varchar(30),
ContactTitle varchar(30),
CusAddress varchar(60),
CusCity varchar(15),
CusRegion varchar(10),
CusPostalCode varchar(10),
CusCountry varchar(15),
CusPhone varchar(24),
CusFax varchar(24),
ShipperCompanyName varchar(40),
ShipperPhone varchar(24)
)
/

-- Copyright (c) 1991 by Oracle Corporation 
--   NAME
--     ulcase3.ctl - <one-line expansion of the name>
--   DESCRIPTION
--     <short description of component this file declares/defines>
--   RETURNS
--
--   NOTES
--     <other useful comments, qualifications, etc.>
--   MODIFIED   (MM/DD/YY)
--    cheigham   08/28/91 -  Creation 
-- 
-- $Header: ulcase3.ctl,v 1.1 1991/09/02 14:52:19 CHEIGHAM Stab $ case3.ctl 
-- 
-- Variable length, delimited and enclosed data format

LOAD DATA 
INFILE '/export/home/biflpu17/spartan/data_files/GF_Orders1.csv'
APPEND

INTO TABLE temporary_orders
FIELDS TERMINATED BY "," optionally enclosed by '"'
trailing nullcols	
( 
OrderId integer,
OrderDate Date,
RequiredDate date,
ShippedDate date,
Shipvia integer,
Freight integer,
ShipName char,
ShipAddress char,
Shipcity char,
ShipRegion char,
ShipPostalCode char,
ShipCountry char,
LastName char,
FirstName char,
Title char,
TitleOfCourtesy char,
BirthDate date,
HireDate date,
EmpAddress char,
EmpCity char,
EmpRegion char,
EmpPostalcode char,
EmpCountry char,
Homephone char,
Extension char,
Photo char,
Notes char,
ReportsTo integer,
CustomerID char,
CompanyName char,
ContactName char,
ContactTitle char,
CusAddress char,
CusCity char,
CusRegion char,
CusPostalCode char,
CusCountry char,
CusPhone char,
CusFax char,
ShipperCompanyName char,
ShipperPhone char  
)