load data infile 'c:\head.csv' replace into table allotment f

How to convert ms-excel file to oracle table?

Question Posted / ts mishra dba

2 Answers
9746 Views
I also Faced
E-Mail Answers

Answer Posted / ts mishra dba

load data
infile 'c:\head.csv'
replace
into table allotment
field terminated by ',' optianally enclosed by '"'
trailing nullcols
(ALLOTMENT_ID,ALLOTMENT_DATE,DEMAND,MAGOR,SUB,MINOR,SCHEEM,S
EGMENT,OBJECT,DETAIL,AMOUNT,DDO_CODE)

run at run command this
sqlldr scott/tiger@ntts control=c:\head.ctl

Is This Answer Correct ?

4 Yes

3 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is the advantage of nosql?

1042

Is sql a oracle?

950

What is sql lookup?

905

What language is oracle sql developer?

985

does sql support programming? : Sql dba

1028

What is the primary key?

933

What is a unique constraint?

1057

What are the advantages of pl sql?

1106

How do I view an execution plan in sql?

966

What is embedded sql with example?

1018

How to select 10 records from a table?

1140

What is sql table?

950

What is partition by in sql?

1048

what is the difference between delete and truncate statement in sql? : Sql dba

1210

what are the differences between procedure-oriented languages and object-oriented languages? : Sql dba

1022