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

What is the Query Optimizer. How you optimize your qeury.

2 Answers   Ericsson,

---

How to find 8th person record in a table? Plz mail ur answers to mak2786@gmail.com Regards Arun

8 Answers  

---

what are the API of GL,PO,AP

0 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 command would you use to create a backup control file?

1 Answers  

---

For web applications from which version of Oracle is suitable?

1 Answers  

---

How do you add a data file to a tablespace?

1 Answers  

---

deference between & and &&

2 Answers   Mphasis,

---

1. What is PO rate variance gain and loss?

0 Answers   Oracle,

---

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

1 Answers  

---

I am Bsc Computer Science Graduate, I have good knowledge in SQL 7.0, Can I go for Oracle APPS course please suggest me the answer

0 Answers  

---

Give two methods you could use to determine what DDL changes have been made.

1 Answers  

---