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;

Explain oracle’s server parameter file.

1041

---

How to assign values to variables?

1163

---

Difference between cartesian join and cross join?

1093

---

What is a cursor in oracle?

1228

---

How to assign a tablespace to a users in oracle?

1089

---

What are temporal data types in oracle?

1167

---

How can we find out the duplicate values in an oracle table?

1119

---

What is set operator oracle?

1034

---

Explain table?

1176

---

How do I reset a sequence in oracle?

1152

---

does the query needs a hint to access a materialized view?

1905

---

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

1982

---

What are the different editions of oracle?

1179

---

What is the fastest query method to fetch data from the table?

1415

---

How to use subqueries with the exists operator in oracle?

1069

---