what are external tables? how can we use external table instead of sql * loader

what are external tables? how can we use external table instead of sql * loader to load data from flat file to staging table?

Question Posted / ch.sreenivaschary

1 Answers
5131 Views
IBM, I also Faced
E-Mail Answers

what are external tables? how can we use external table instead of sql * loader to load data from fl..

Answer / priyanka

External table is like ctl file syntax but with in database script this will pick up the file from database then load data in to staging table.

Is This Answer Correct ?

1 Yes

0 No

Post New Answer

More Oracle Apps Technical Interview Questions

HOW CAN U KNOW THE RESPONSIBILITY BELONGS TO OPERATING UNIT LEVEL OR NOT

2 Answers

Pls tel me the best text book for Oracle Apps 11i Tech? & I want D2K Text book also?

0 Answers

WHAT IS REFCURSOR IN ORACLE ?

6 Answers

in sql *loder how to skip the middle records ex:from 10th to 20th records i want to skip?

2 Answers Oracle, Schneider,

What is an Index , Types od index why we are use index.

2 Answers IBM,

What r the type Models in the system parameters of the report?

1 Answers

how can we get odd numbered pages in output of a report

2 Answers Infosys,

Explain what are the tables of auto invoice?

0 Answers

How to attach the multiple templates in XML Pub Report?

2 Answers Intelligroup, KPIT,

After execution of a report we get parameter layout where we have enter From_date and To_date.After entering From_date and without entering To_date what happen a report will execute or not?

2 Answers HCL,

while running a interface if we get 100 records as erors. how to debug it.

2 Answers Zensar,

HOW MANY LANGUAGES FOLDERS ARE ONE ORACLE APPLICATION

1 Answers TCS,

For more Oracle Apps Technical Interview Questions Click Here