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

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

More Oracle Apps Technical Interview Questions

what is fiscalcalendar?

in one report using two layout models.if yes how to do

What is the maximum number of statements that can be specified in a trigger statement?

What and Who is the best Institute or Trainer for Oracle Apps Technical ?

mention the interface tables for item open interface and open transaction interface and also their respective production tables.

Stored procedure?

Which oracle apps version you are very confident in?

IN WHICH MODULE THE LEGAL ENTITY COMES?

what is Flex mode and Confine mode?

If there is any issue then whom do you report.(this is imp question for every interview)

How many typres of Purchase order and what are those.

how can develope the po variance and po summary report? with tables mandatory columns and query please?

For more Oracle Apps Technical Interview Questions Click Here