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

What is java sql driver?

550

---

how to shutdown mysql server? : Sql dba

570

---

Are stored procedures faster than queries?

524

---

how to use regular expression in pattern match conditions? : Sql dba

530

---

Are stored procedures faster than dynamic sql?

535

---

---

how does a local variable is defined using t-sql? : Transact sql

547

---

How do I restart sql?

527

---

Is left join faster than inner join?

620

---

How to load data with sql*loader?

552

---

Can sql function call stored procedure?

560

---

How to Declare Fixed Length String Value In PL SQL

668

---

What is trigger point?

540

---

Is left join same as join?

524

---

What is a sql schema used for?

546

---

What are the types of variable use in pl sql?

567

---