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 are the balancing segments in AR?

Can you define an erp system?

What are the different components you should consider while defining a responsibility in oracle apps?

where is setup of business group done?

which parameters passed in report in oracle developer how to pass

what is the difference between po_vendors & po_headers_all? does po_vendors relate to opeating unit?

what type of testing u r doing?

While running the concurrent program we will get the status, we have to change the status. How it will be done.

tell me the scenarios of between pages in reports

What is SRW Package? (Sql Report Writer)

what is the data type of lexical parameter?

What are profile options?

For more Oracle Apps Technical Interview Questions Click Here