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

what is datawarehouse? : Sql dba

1059

---

Do ddl statements need commit?

1017

---

What is pl sql code?

1099

---

What are all types of user defined functions?

1130

---

What does inner join mean?

1256

---

How do I debug a stored procedure?

1159

---

Explain the insert into statements in sql?

1049

---

what are myisam tables? : Sql dba

1074

---

What is integrity in sql?

1100

---

What is execution plan in sql?

1088

---

Is left join inner or outer by default?

1067

---

What is bulk compiling in pl/sql.?

1186

---

List and explain the different types of join clauses supported in ansi-standard sql?

1400

---

What is difference between function and trigger?

1106

---

Why use subqueries instead of joins?

1132

---