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 This Answer Correct ? | 5 Yes | 1 No |
Post New Answer View All Answers
q)what are the validations in sql*loader
what is global tempory table?
what are the prerequisites for costing transactions?
What is oracle soa suite?
can we get profile values in report without using user exists is it possible how?
In hierarchical structure of a database? we have write query from where we should start?
How many schemas we have? how many you have used?
How can a process be deployed in soa?
do you know is it possible to run the interface without using oracle apps?
What do you understand by a set of books?
Do you know where we can check the status of po?
what are the balancing segments in AR?
testing tools?
what is the differences between internal requisition and internal sales order?
please any one provide the oracle erp technical interview questions on modules(PO,AP,AR,INV,GL,OM)wise to my mail id..narendra_609@yahoo.co.in
