Answer / emmanuel - tcs

Sql * loader used to transfer Huge data from legacy to
oracel database. It's supports .dat,.xls etc.. files.

5 types of files are there.

Flat file -- .dat file
Control file -- Control file program
Bad file -- Stores the all error records
Discard file -- stores all the discard filed (WHEN Condi)
Log file -- Shows the status of the Control file

Thanks
Emmanuel - TCS

Answer / guest

Sql * loader is a bulk loader utility used for moving data
from external files into the oracle database.
Sql * loader supports various load formats, selective
loading, and multi-tables loads.
1) conventional
--The conventional path loader essentially loads the
data by using standard ?insert? statement.
2) direct
-- the direct path loader (direct = true)
by possess of logic involved with that, and loads directly
in to the oracle data files.
EX:-
My data.csv file
1001, ?scott tiger?,1000,40
1002,?gvreddy?,2345,50
Load data
Infile ?c:\data\mydata.csv?
Into table emp
Fields terminated by ?,? optionally enclosed by ???
(empno, empname,sal,deptno)
>sqlldr scott/tiger@vis
control=loader.ctl log= gvlog.log bad=gvbad.bad
discard=gvdis.dsc .

i have 100 pages output. i want to print 10 records per page in Template?

2 Answers   Sierra Atlantica,

---

what is lexical parameter?

3 Answers   TCS,

---

Difference between set of books id and ledger id in r12 ?

1 Answers   TCS,

---

what r the objects u have to do in u experiance

1 Answers  

---

link between po and ap modules

5 Answers   ERP Solutions,

---

Stored procedure?

4 Answers  

---

what is difference between procedure and function

5 Answers   E Logic,

---

where is setup of business group done?

2 Answers   TCS,

---

IN WHICH MODULE THE LEGAL ENTITY COMES?

5 Answers  

---

WHAT IS CUSTOM VIEW AND CUSTOM COMPONENT?

0 Answers   Tech Mahindra,

---

Can you define an erp system?

0 Answers  

---

How is choreography different from orchestration?

0 Answers  

---