what is External tables? explain with examples
- 2 Answers
- 13028 Views
- TCS, I also Faced
- E-Mail Answers
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
How do you modify a column in sql?
Can cursors be part of a trigger body?
What is memory optimized table?
What is varchar sql?
Can delete statement be rollbacked?
What is union?
What is cursor and its types?
How do you pronounce sql?
What are the uses of sysdate and user keywords?
explain primary keys and auto increment fields in mysql : sql dba
Which sorts rows in sql?
Which join is default?
What are the methods of filing?
What is full join in sql?
what is the use of set statement in tsql? : Transact sql
