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.

How do you delete a table?

535

---

How can the performance of a trigger be improved?

588

---

how to write date and time literals? : Sql dba

528

---

What are different functions in sql?

514

---

Can we use delete in merge statement?

512

---

---

What is the difference between syntax error and runtime error?

612

---

Can we insert in view in sql?

560

---

what is data manipulation language? : Sql dba

527

---

Can there be 2 primary keys in a table?

553

---

What are the different sql languages?

538

---

What is string data type in sql?

530

---

Can we insert data into materialized view?

503

---

How many developers work on postgresql?

559

---

how to install mysql? : Sql dba

580

---

what are the nonstandard string types? : Sql dba

601

---