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 difference between the conventional and direct path loader? : aql loader

1110

---

What is cursor status?

1135

---

How can you fetch first 5 characters of the string?

946

---

explain the delete statements in sql

976

---

How to connect a sql*plus session to an oracle server?

1079

---

What is the advantage of index in sql?

915

---

What is use of trigger?

873

---

Hi how to import oracle sequence in Informatica? Please write stored procedure code that will import oracle sequence in Informatica SP transformation as per below scenario Oracle table product list Pro_id, pro_name 101, LED Lights. 102, 20watt CFL Lights. 103, 30 watt CFL lights Now a new flat file with new product list needs to be added to oracle table product list with oracle sequence. flat file product Prono,pro_name, 1, 20 watt tube light 2, 30 watt tube light & target should be like 101, LED Lights. 102, 20watt CFL Lights. 103, 30 watt CFL lights. 104, 20 watt tube light 105, 30 watt tube light thks reg suvarna joshi suvarnaatsuvarna@rediffmail.com

2481

---

Why do we use function in pl sql?

1006

---

What types of commands can be executed in sql*plus?

1048

---

Can we use rowid as primary key?

941

---

How do I run a pl sql procedure in sql developer?

911

---

What is query optimization in sql?

936

---

Explain how to use transactions efficiently : transact sql

922

---

What is posting?

990

---