what is sql*loader parameters and where we will use it.

Question Posted / husenaiahb

1 Answers
7204 Views
Accenture, I also Faced
E-Mail Answers

what is sql*loader parameters and where we will use it...

Answer / arijitnit

sql*loader is a bulk importing tool to import data tables
present in various formats like CSV.
We have to define a control file and in it we have to give
some commands.
LOAD DATA
INFILE *(this assumes data is in the same ctl file)
INTO TABLE TABLE_NAME(COLUMNS)
FIELDS TERMINATED BY ;
BEGIN DATA

...DATA IN CSV FORMAT
now in command prompt type sqlldr USERID=scott/tiger
CONTROL=test.ctl

Is This Answer Correct ?

7 Yes

0 No

Post New Answer

More Oracle AllOther Interview Questions

What is the difference between conversions and interfaces? : oracle accounts receivable

0 Answers

What is autocashrule set? : oracle accounts receivable

0 Answers

i want to know about the javaBean.what is its purpose and how it can use in Forms.

0 Answers Logisoft,

Difference between negative and positive adjustments : oracle accounts receivable

0 Answers

What are different types of transactions in ar? : oracle accounts receivable

0 Answers

I've got a database 10g and Form version 5.0 but unable to connect. Does Oracle 10g database supports form 4.5

0 Answers jusco,

1)After defining value set we define list of values, I need to enter 1000 values with out entering manually, how will you do that? 2)what are the parameters we use in a concurrent program? 3)what is payroll processing? 4)In organization window after defining an organization and organization classification how to create a new item in the others button? 5)If there are 10 users, How to restrict the selected users not to access the forms?

0 Answers Cap Gemini,

What is the Query Optimizer. How you optimize your qeury.

2 Answers Ericsson,

When the procedures or packagess become invalidate

3 Answers TCS,

Explain the difference between $ORACLE_HOME and $ORACLE_BASE.

2 Answers

What view would you use to determine free space in a tablespace?

0 Answers

Hi, I want to know basic information about Oracle HRMS and the institutes in hyderabad or the best faculty as i want to make my career in it.And also want to know may a person from non technical background be able to do this course. Regards, Swetha

0 Answers

For more Oracle AllOther Interview Questions Click Here