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

HOW TO SAVE UNIVERSES AND DOCUMENTS IN THE REPOSITORY?

0 Answers  

---

What command would you use to encrypt a PL/SQL application?

1 Answers  

---

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

0 Answers  

---

You have just compiled a PL/SQL package but got errors, how would you view the errors?

1 Answers  

---

Give the stages of instance startup to a usable state where normal users may access it.

1 Answers  

---

statement string in open is null or 0 length ORA-40735

1 Answers   RoboSoft, Unilog,

---

Explain the difference between a data block, an extent and a segment.

1 Answers   Accenture, IBM,

---

What do you mean by hz_ in customer tables? : oracle accounts receivable

0 Answers  

---

Explain how to account for bank charges deducted from amount received against an invoice. : oracle accounts receivable

0 Answers  

---

What is the difference between the SQL*Loader and IMPORT utilities?

1 Answers  

---

A Table has 10,000 records,How can i get latest 10 dates from the table.so that i can only store those 10 records in to my Resultset Object,to reduce load on my app?

7 Answers   TCS,

---

which gives Oracle R12 Financial training in delhi please give me answer its urgent?

0 Answers  

---