Member Avatar for apanimesh061

<prjt.ctl>

LOAD DATA
	INFILE 'F:\DataMining\dvdlist.csv'
	DISCARDFILE 'F:\Datamining\Discard\dvdlist.dis'
INTO TABLE dvdlist
FIELDS TERMINATED BY ","
OPTIONALLY ENCLOSED BY '"'
TRAILING NULLCOLS(
	DVD_Title char,
	Studio char,
	Released date "DD-MM-YYYY" NULLIF Released=BLANKS,
	Status char,
	Sound decimal external,
	Versions char,
	Price char,
	Rating char,
	Years char,
	Genre char,
	Aspect char,
	UPC integer external,
	DVD_ReleaseDate date "DD-MM-YYYY" NULLIF DVD_RealeaseDate=BLANKS,
	ID  integer external,
	Timestamp date "DD-MM-YYYY"
)

<dvdlist Table>

CREATE TABLE dvdlist(
	DVD_Title varchar2(100) not null,
	Studio varchar(40) not null,
	Released date default sysdate,
	Status char(20),
	Sound decimal,
	Versions varchar2(20),
	Price char(10) not null,
	Rating varchar2(10),
	Years char(4) default 'UNK',
	Genre char(10),
	Aspect varchar2(10),
	UPC integer,
	DVD_ReleaseDate date default sysdate,
	ID integer,
	Time_stamp date default sysdate
);

I have attached the csv file that I want to load.
I am having problem in loading Date formats in the csv file and the format that Oracle accepts.
And what should I do for long integers in the ctl integers ??
:?:

Please help!
Thanks!

dvdlist.zip (1535.71 KB)
  • 2 Contributors
  • 1 Reply
  • 140 Views
  • 3 Days Discussion Span
  • Latest Post Latest Post by debasisdas
Member Avatar for debasisdas

Better to load the dates as string and convert later.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.