what is External tables? explain with examples
Answer Posted / jayaprakash gutti
External table is a complement to SQl* Loader.
External table is more faster compared to SQL loader when
there is thousands of records in source data file.
When we create External table, a link is established between
external table and source data file (which is located in the
file system/Oracle Server).
whenever we query external table like:
select * from external_table;
it fetches data from the file and displayed.
also, external tables are read-only.
you can't perform DML operations.
we can insert the data in the external table to any of the
data base table we want.
Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What is difference between cursor and trigger?
What are the two types of periodical indexes?
Define join and name different types of joins?
What are the different sql commands?
What are variables in pl sql?
Explain the uses of control file.
What does := mean in pl sql?
How many types of sql are there?
What are predefined functions in sql?
What are sql injection vulnerabilities?
Are there any features that are decommissioned in 11g that are not present in 11g?
Why cannot I use bind variables in ddl/scl statements in dynamic sql?
How can you tell the difference between an index and a view?
What is the best sql course?
What is compilation error in pl sql?