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
9805 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 column?

996

What is sql and db2?

1012

what is difference between delete and truncate commands? : Sql dba

1136

Can we call stored procedure in function?

963

Explain what is sql*plus?

1149

Do ddl statements need commit?

974

what does it mean to have quoted_identifier on? What are the implications of having it off? : Sql dba

1007

What is a call statement? Explain with an example.

1014

How would you reference column values before and after you have inserted and deleted triggers?

1066

How do I start sql profiler?

1000

What is the order of sql select?

1041

What is difference between pl and sql?

1066

Is sql better than excel?

1158

how to show all tables with 'mysql'? : Sql dba

1119

How do I trace sql profiler?

987