Answer Posted / karkuvelrajan muthusamy

External tables can be used to fetch data from a physical
data file present in the OS path of the database server.. It
is similar to SQL*Loader where oracle reads data from a
datafile and loads into oracle tables.. An external table is
very similar.. Whenever we create an eternal table, oracle
doesnot load data from file instead a table that referes to
the file only is created.. A sample syntax could be as
following:

create table ext_tbl
(e_name varchar2(50),
e_sal number)
ORGANIZATION EXTERNAL(
TYPE ORACLE_LOADER
-- Default->ORACLE_LOADER, Oracle_datapump can also be used
DEFAULT DIRECTORY ext_dir
-- An oracle directory has to be created with
-- name ext_dir
ACCESS PARAMETERS
(
FIELDS TERMINATED BY ','
RECORDS DELIMITED BY NEWLINE
MISSING FIELD VALUES ARE NULL
(e_name, e_sal)
)
LOCATION('file1.txt')
)

The file1.txt should be in the following format:
Kumar,20000
Raj,10000
Patel,34000

Hope this helps.

Regards,
Karkuvelrajan M

how to calculate expressions with sql statements? : Sql dba

1034

---

What is bulk compiling in pl/sql.?

1130

---

How do I order columns in sql?

1008

---

Explain the update statement in sql

994

---

What is composite data type in pl sql?

1113

---

How to call shell script from pl sql procedure?

1281

---

What are the various levels of constraints?

1125

---

What is an implicit commit?

1058

---

How do you create a unique index?

1049

---

What is out parameter used for eventhough return statement can also be used in pl/sql?

1078

---

What is a table partition?

1134

---

How long does it take to learn pl sql?

1062

---

Are dml statements autocommit?

1045

---

How do I get sql certification?

975

---

What is the syntax to add a record to a table?

1090

---