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 .

What is the Use of User Exit in Oracle apps and when we are developeing the new report you need to pass one parameter called P_CONC_REQUEST_ID,what is the use of this parameter and is it mandatory.Can't we develop report without this User exit's and P_CONC_REQUEST_ID parameter

12 Answers   TCS,

---

What is the result of this query ? SELECT * FROM EMP WHERE ROWNUM = 1

25 Answers   IBM, Satyam,

---

what is MRC? Why it is needed?

4 Answers   Convergys,

---

what is difference between d2k report and oracle apps report

2 Answers   iFlex, TCS,

---

in one report using two layout models.if yes how to do

2 Answers  

---

---

Hi  Friends this is preetham, i am  searching for job on oracle apps(technical) i put 3 years fake exp, so any one  please could you help me for realtime interview  questions and 9739782164 this is my no srpsrp777@gmail.Com please guys please provide your no for contact i have a doubts i want to clarify

0 Answers   IBM,

---

How to create user and how u attach with responsibility.

2 Answers   Accenture,

---

what is the defference between credit memo and debit memo

2 Answers  

---

We have to show a logo/image in a report? what are the steps and which format it is?whether in pdf format is applicable or not?

3 Answers   IBM,

---

What is the Exception. Types of exception, Difference between those. And example

2 Answers   IBM,

---

In which table or database definition we can find the link of organization and operation units.

2 Answers   IBM,

---

where we can check the status of po.

4 Answers  

---