Interested to Buy Any Domain ? << Click Here >> for more details...
Tell me some thing about SQL-LOADER.
- 2 Answers
- 23879 Views
- IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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
| Is This Answer Correct ? | 9 Yes | 1 No |
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 .
| Is This Answer Correct ? | 5 Yes | 1 No |
Is PlaceHolderColumn Function or Procedure? Why we don't write any code in that?
any one can expalin report registration steps?
What is P2P cycle.
27 Answers Accenture, Deloitte, EE Limited, EXL, IBM, Tech Mahindra,
What is Value Set?
what is the difference between character mode,bitmap mode
2 Answers IBM, Sierra Atlantica,
How can u find custom top? where its located? How to find custom top in front end?
Attribute data types?
What r the validation done in ap inbound ?
List the types of flexfield?
How will u register concurrent request ?
In a table their 20 records.I had update 6 records???How can see and retrieve particular 6 records.i.e.,Latest updated.
10 Answers HCL, TCS,
what is instead of trigger in where u will use?
Oracle Apps Technical 
