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

A scenario for amount correction & how to use amount correction functionality in AP invoices

0 Answers  

---

How do you resize a data file?

2 Answers  

---

hi iam looking for HRMS(functional) training inst or person in hyderbad. plz help me its urgent

1 Answers  

---

what is the link between suppliers and banks in ap module in oracle apps? And also query?

0 Answers   Polaris,

---

Explain the payment term in ar. : oracle accounts receivable

0 Answers  

---

Compare and contrast TRUNCATE and DELETE for a table.

3 Answers  

---

what are the tools used for oracle 10g in real time.

0 Answers   IBM,

---

Why more redos are generated when the oracle database is in begin backup mode?

0 Answers  

---

What is difference b/w Credit memo and Adjustment in AR.

1 Answers   Oracle,

---

What is database schema?

4 Answers   Infosys,

---

What is index? How many types of indexes?

2 Answers   HCL,

---

why r u using etl tool.

2 Answers  

---