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
What is oracle soa suite?
What is a flexfield? List out its types.
What is count(*) from po_vendors(any table)?
what are the different transaction clauses in AR?
What do you understand by a set of books?
How many schemas we have? how many you have used?
Do you know what are user profiles in apps. Any examples you can give?
What are the different components you should consider while defining a responsibility in oracle apps?
What are the Standard Reports and Forms in HRMS?
Which oracle applications pl/sql standard apis you are familiar, have you used most of them?
how can i print random rows in plsql table
In hierarchical structure of a database? we have write query from where we should start?
can we use look up type instead of a pofile option?or valueset?is it possible how?
Explain what are the tables of auto invoice?
What do you understand by soa and what are the benefits of using this architecture?