Interested to Buy Any Domain ? << Click Here >> for more details...
what is External tables? explain with examples
- 2 Answers
- 13819 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
What is the least restrictive isolation level? : Transact sql
What is the difference between microsoft access and sql?
Write a program that shows the usage of while loop to calculate the average of user entered numbers and entry of more numbers are stopped by entering number 0?
How do you modify a trigger?
What is delete command in sql?
How do I turn a list into a table?
What are some predefined exceptions in pl/sql?
Which is better stored procedure or query?
What is the starting oracle error number? What is meant by forward declaration in functions?
what is isam? : Sql dba
What is sql keyword?
Can we create clustered index without primary key?
What is trigger explain with example?
Which join is default?
What are properties of the transaction?
