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

which one is currently in used software cmpanies.

0 Answers  

---

Explain the use of table functions.

0 Answers  

---

what is sql*loader parameters and where we will use it.

1 Answers   Accenture,

---

What is auto accounting what are the steps for setting up auto accounting? : oracle accounts receivable

0 Answers  

---

What is store procedure?and how do u take the values from database and run in scripts?

2 Answers   Polaris,

---

---

HOW TO SAVE UNIVERSES AND DOCUMENTS IN THE REPOSITORY?

0 Answers  

---

Explain prerequisites and post activities of oracle database installation

0 Answers  

---

what is domain in database and its benefits?

0 Answers  

---

How would you determine what sessions are connected and what resources they are waiting for?

0 Answers  

---

Give two examples of how you might determine the structure of the table DEPT.

2 Answers  

---

can u tell me how many types of oracle and which type all detail in oracle (suppose all history of oracle )

1 Answers   IBM, Oracle,

---

what is the querry to get first 10 records from the emp table?(emp no is the primary key)

4 Answers   Verizon,

---