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 trigger and stored procedure in sql?
What are the set operators in sql?
What is embedded sql with example?
What is cursor in pl sql?
How to fetch values from testtable1 that are not in testtable2 without using not keyword?
How you improve the performance of sql*loader? : aql loader
What sql does db2 use?
What are the advantages of sql?
what are date and time functions in mysql? : Sql dba
Is sql scripting language?
Where are my tempfiles, I don't see them in v$datafile or dba_data_file?
Is primary key an index?
Can we create foreign key without primary key?
how many ways we can we find the current date using mysql? : Sql dba
How do I create an index in word?