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;

Can we save images in a database and if yes, how?

1057

---

What happens if you set the sga too low in oracle?

1136

---

How to write a left outer join with the where clause in oracle?

1078

---

What is oracle instant client?

1020

---

Write a syntax for update query in oracle?

1023

---

Explain the use of indexes option in imp command.

1166

---

How to compare dates in oracle sql?

1094

---

How to start a new transaction in oracle?

1079

---

How does the on-delete-cascade statement work?

1098

---

In XIR2 if we lost the administration password .How can we regain the password?thanks in advance.

1928

---

What are the benefits of ordbms?

1081

---

What is index-organized table in Oracle?

1063

---

how to make an oracle object

2348

---

What is the relation of a user account and a schema?

1125

---

Explain the difference between sap and oracle?

1027

---