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
Define select, insert, create, delete, update, drop keywords
What does select count (*) mean in sql?
What is pl sql collection?
What is an inner join sql?
What is view explain with example?
How do I run sql?
What is #table in sql?
What are triggers and its types?
discuss about myisam key cache. : Sql dba
Explain raise_application_error.
How do I start pl sql?
What is exit statement?
Is sql better than excel?
How to start the command-line sql*plus?
what is clause? : Sql dba
