Oracle Developer - What is SQL*Loader ? Describe .

GeekInterview.com > Certification > Oracle > Oracle Developer

Go To First | Previous Question | Next Question

Oracle Developer | Question 15 of 23

What is SQL*Loader ? Describe .

Total Answers and Comments: 6

Last Update: December 24, 2007 Asked by: skmishra_it

Sponsored Links

Best Rated Answer

—

Submitted by: mala321

Hello,

SQL * LOADER is a utility tool which comes inbulit with any versions of Oracle. it is used to load data (.txt,.xls, tables, Doc ...) any flat files of this type can be loaded into Oracle database tables.

It can take one single flat file and load data into one table in Oracle DB or many tables at a single load
or
it can also take multiple flat files and load data too.
in SQL LOADER main are

Control file , Data file , badlog file,discard file

control file is the key file which contains info about remaining files DATA<BADLOG,discard

it also contains info about which table is going to be populated with this flat files
and datatypes....

Data file--which containd data in the form of a simple lines comma separated, delimiters...

so far this must be give you some idea. Good luck

bye
Mala

Above answer was rated as good by the following members:
pratap5655

February 11, 2006 22:46:48

manish shrivastava

RE: What is SQL*Loader ? Describe .

Sql is a utillty by which we populate the by a opreting system file (say *.txt)

to decribe the table we use ctl file syntx is as follow

sqlldr user/passwd control xxx.ctl log abc.log data lmn.dat

structure of ctl file is as follow

LOAD DATA
INTO TABLE table name
REPLACE
FIELDS TERMINATED BY WHITESPACE
TRAILING NULLCOLS
(
col1
col2 .....
)

there are two technicq (as i know )to use sqlldr first i mention here i leave second one for your SEARCH

Rgds

Manish

Is this answer useful? Yes | No

April 01, 2006 21:41:09

sam

RE: What is SQL*Loader ? Describe .

SQL Loader is a utility to load data on to an oracle database from an external source.

There are demo files to demonstrate the use of this uitility and the location is C:\oracle\ora92\rdbms\demo

Is this answer useful? Yes | No

July 11, 2006 01:54:14

ALOK TANDON

RE: What is SQL*Loader ? Describe .

SQL loader is a tool provided by oracle to load data into the tables through flat files.

Is this answer useful? Yes | No

February 27, 2007 00:44:17

SHEEL2006

RE: What is SQL*Loader ? Describe .

SQL loader is a tool provided by oracle to load data any other type of rdms file is converted into oracle rdms system

Is this answer useful? Yes | No

August 18, 2007 03:57:53

SrikanthPeru

Member Since: August 2007 Contribution: 1

RE: What is SQL*Loader ? Describe .

SQL*Loader is a tool used to load flat files quickly into Oracle Tables. Using this a single flat file can be loaded into multiple tables during the same load.

Is this answer useful? Yes | No

December 24, 2007 00:55:51

mala321

Member Since: December 2007 Contribution: 6

RE: What is SQL*Loader ? Describe .

Hello

SQL * LOADER is a utility tool which comes inbulit with any versions of Oracle. it is used to load data (.txt .xls tables Doc ...) any flat files of this type can be loaded into Oracle database tables.

It can take one single flat file and load data into one table in Oracle DB or many tables at a single load
or
it can also take multiple flat files and load data too.
in SQL LOADER main are

Control file Data file badlog file discard file

control file is the key file which contains info about remaining files DATA<BADLOG discard

it also contains info about which table is going to be populated with this flat files
and datatypes....

Data file--which containd data in the form of a simple lines comma separated delimiters...

so far this must be give you some idea. Good luck

bye
Mala

Is this answer useful? Yes | No

1 0

Overall Rating: +1

Go To Top

User Name		Remember Me?
Password

Question Bank