Answer Posted / 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 .

Is soa a part of oracle fusion middleware?

1090

---

List the various types of value set.

1082

---

In oracle application how do you debug or trace errors?

1116

---

please send me forms, xml pulisher questions,answers

2113

---

can we use look up type instead of a pofile option?or valueset?is it possible how?

2225

---

What is count(*) from po_vendors(any table)?

1089

---

What does appl_top directory contain?

1122

---

What is the concept of soa governance?

1255

---

In hierarchical structure of a database? we have write query from where we should start?

2246

---

What is oracle soa suite?

1238

---

Which oracle apps version you are very confident in?

1213

---

what are the balancing segments in AR?

2101

---

Tell me where we find the status of order information?

1140

---

Can you explain the difference between architecture followed in 10g & 11g?

1072

---

pls send me out bound code of supplers,site,bankiformation code pls as soon as

2266

---