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 client makes connection with server in client/server architecture?

1 Answers   CA,

---

Is Oracle 7.3 is a single user or multi user..Is it possible to use this as a backend for web applications?

2 Answers  

---

Explain an ORA-01555

2 Answers  

---

where the dff data will be stored

0 Answers   Infosys,

---

For web applications from which version of Oracle is suitable?

1 Answers  

---

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

0 Answers  

---

What command would you use to create a backup control file?

1 Answers  

---

Whats the purpose of using Nextval while creating the sequence.

2 Answers   HCL,

---

What does coalescing a tablespace do?

2 Answers  

---

What is autocashrule set? : oracle accounts receivable

0 Answers  

---

Name a tablespace automatically created when you create a database.

3 Answers   HCL,

---

IS IT POSSIBLE TO CREATE REPORTS FROM DIFFERENT UNIVERSES IN ONE DOCUMENT?

0 Answers  

---