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
What is the advantage of nosql?
Is sql a oracle?
What is sql lookup?
What language is oracle sql developer?
does sql support programming? : Sql dba
What is the primary key?
What is a unique constraint?
What are the advantages of pl sql?
How do I view an execution plan in sql?
What is embedded sql with example?
How to select 10 records from a table?
What is sql table?
What is partition by in sql?
what is the difference between delete and truncate statement in sql? : Sql dba
what are the differences between procedure-oriented languages and object-oriented languages? : Sql dba