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.

What is sql indexing?

1056

---

Is a secondary key the same as a foreign key?

1110

---

How do you exit in sql?

1156

---

Why is %isopen always false for an implicit cursor?

1149

---

what is the difference between a having clause and a where clause? : Sql dba

1154

---

how to fetch alternate records from a table? : Sql dba

1161

---

What is delete command in sql?

1165

---

Define a temp table?

1075

---

Can there be more than one function with a similar name in a pl/sql block?

1036

---

How do I access sql anywhere database?

1019

---

how to increment dates by 1 in mysql? : Sql dba

1027

---

what are the join types in tsql? : Transact sql

1099

---

Can two tables have same primary key?

1018

---

How many triggers can be applied to a table?

1121

---

List the different type of joins?

1111

---