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 does pl sql developer do?

882

---

what is 'mysqlcheck'? : Sql dba

959

---

How many types of keys are there in sql?

986

---

Is vs as in pl sql?

933

---

Is left join same as join?

937

---

Which operator is used in query for pattern matching?

1032

---

Explain character-manipulation functions?

1067

---

What is mutating table error?

1116

---

what is data manipulation language? : Sql dba

945

---

How to avoid using cursors? What to use instead of cursor and in what cases to do so?

1124

---

Which sql most popular?

935

---

What is the purpose of cursors in pl/sql?

1078

---

Is postgresql a nosql database?

1074

---

Can we edit a view in sql?

925

---

How does one use sql*loader to load images, sound clips and documents? : aql loader

1117

---