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 trigger and stored procedure in sql?

1092

---

What are the set operators in sql?

1136

---

What is embedded sql with example?

1099

---

What is cursor in pl sql?

1187

---

How to fetch values from testtable1 that are not in testtable2 without using not keyword?

1285

---

How you improve the performance of sql*loader? : aql loader

1063

---

What sql does db2 use?

1028

---

What are the advantages of sql?

1100

---

what are date and time functions in mysql? : Sql dba

1024

---

Is sql scripting language?

1115

---

Where are my tempfiles, I don't see them in v$datafile or dba_data_file?

1055

---

Is primary key an index?

1036

---

Can we create foreign key without primary key?

1038

---

how many ways we can we find the current date using mysql? : Sql dba

1144

---

How do I create an index in word?

1074

---