Interested to Buy Any Domain ? << Click Here >> for more details...
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 difference between a web-garden and a web-farm? : Sql dba
What does the sign mean in sql?
Can primary key be changed?
How do you define a foreign key?
What is the usage of distinct keyword?
Enlist some predefined exceptions?
what is a stored procedure? : Sql dba
Why is pl sql needed?
What is the difference between row level and statement level trigger?
Does truncate free space?
what is try_catch block in procedure
Why do we need sharding?
What is a loop in sql?
Can you inner join the same table?
What are string functions in sql?
