Answer / arijitnit

sql*loader is a bulk importing tool to import data tables
present in various formats like CSV.
We have to define a control file and in it we have to give
some commands.
LOAD DATA
INFILE *(this assumes data is in the same ctl file)
INTO TABLE TABLE_NAME(COLUMNS)
FIELDS TERMINATED BY ;
BEGIN DATA

...DATA IN CSV FORMAT
now in command prompt type sqlldr USERID=scott/tiger
CONTROL=test.ctl

i have marks in table,how to find total?

1 Answers  

---

how can we send a concurrent program output to the clients through mail or fax give me example.

1 Answers   Cap Gemini,

---

What are the advantages of operating a database in ARCHIVELOG mode over operating it in NO ARCHIVELOG mode in Oracle?

0 Answers  

---

Whats the purpose of using Nextval while creating the sequence.

2 Answers   HCL,

---

What Are Cross Validation & Adi?

0 Answers   Oracle,

---

---

What is db_recovery_file_dest in oracle? When do you need to set this value?

0 Answers  

---

TILL WHAT LEVEL OF SECURITY BO SUPPORTS?

1 Answers  

---

default triggers available for reports

0 Answers  

---

key flexfield structure

0 Answers   Infosys,

---

Explain how to close periods in ar. : oracle accounts receivable

0 Answers  

---

Differentiate between unidentified receipt, unapplied receipts and on account receipts? : oracle accounts receivable

0 Answers  

---

How would you force a log switch?

1 Answers  

---