Answer Posted / susil kumar rout

Generally pl/sql table can create at the run time.
It is virtual table contains 2 columns
1-binary index.
2-data type upon which pl/sql table is created.
example-
Type typename is table of emp.ename%type
index by binary_integer;

What are the uses of a database trigger?

926

---

20. Using a set operator, display the client number of all clients who have never placed an order.

2144

---

How to write numeric literals in oracle?

1123

---

What is the dynamic sql in oracle?

1007

---

Explain the use of indexes option in exp command.

1063

---

How do I connect to oracle database?

1023

---

What is proxy method?

928

---

Why is oracle so popular?

941

---

How to retrieve values from data fields in record variables?

1033

---

How to drop a stored function?

1083

---

What is oracle data type?

901

---

Hi Can any one tell me what are the API's used in requisition import.

1879

---

What are the various types of snapshots ?

970

---

How to empty your oracle recycle bin?

980

---

How to use fetch statement in a loop?

971

---