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 the basic form of sql query?

891

---

What is package in pl sql?

973

---

How many columns should be in an index?

913

---

What is the maximum rows in csv?

873

---

What is a full join sql?

988

---

What are the most important characteristics of pl/sql?

1093

---

Does mysql support pl sql?

1107

---

What is Materialized View? In What Scenario we Use Materialized View?

9420

---

what are the other commands to know the structure of table using mysql commands except explain command? : Sql dba

1003

---

table structure: ---------------- col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10 01-mar-2012 11:12:46 01-mar-2012 11:11:23 Write a query to display the result as shown below: col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10

4121

---

How to write a query to show the details of a student from students table whose

952

---

what is cross join? : Sql dba

953

---

What is sql character function?

1007

---

what is sub-query? : Transact sql

1051

---

Explain what is a field in a database and record in a database?

1026

---