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

Do we need to rebuild index after truncate?

1151

---

Does group by remove duplicates?

1120

---

what are aggregate and scalar functions? : Sql dba

1142

---

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

1125

---

what is sql server agent? : Sql dba

1188

---

what is collation? : Sql dba

1242

---

what is schema? : Sql dba

1163

---

what is bcp? When does it used? : Sql dba

1065

---

define sql insert statement ? : Sql dba

1108

---

Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me

2099

---

Is primary key always clustered index?

1101

---

What is the current version of postgresql?

1188

---

Is inner join faster than left join?

1287

---

what are all the common sql function? : Sql dba

1141

---

What is your daily office routine?

2351

---