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.

discuss about myisam index statistics collection. : Sql dba

942

---

What are character functions?

1079

---

How can we optimize a sql query?

1043

---

What is trigger with example?

1085

---

What is cross join sql?

911

---

what is recursive stored procedure? : Sql dba

977

---

What are analytic functions in sql?

1019

---

What action do you have to perform before retrieving data from the next result set of a stored procedure ?

2564

---

How can I get the number of records affected by a stored procedure?

1056

---

Is oracle sql free?

978

---

What sql database should I use?

1134

---

Is sql an operating system?

1014

---

What is cursor status?

1183

---

What are the different types of tables in sql?

994

---

What is the difference between subquery and correlated query?

1055

---