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 r the validation done in ap inbound ?

Can functions be overloaded ?

Oracle E-Business suite?

If the flat file is having the duplicate records in the interface how can you restrict while transferring the flat file data in to interface tables?

I am insert in data to a table X .Which one is better while writing commit statement After each row inset or after all row insert to table.

Can we create tables in apps schema?

Can 2 functions have same name & input parameters but differ only by return datatype ?

List the various types of value set.

can we use look up type instead of a pofile option?or valueset?is it possible how?

what are the steps to develop a new report?

in GL module specifing org_id or not?

tell me the scenarios of between pages in reports

For more Oracle Apps Technical Interview Questions Click Here