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;

How do I use os authentication with weblogic jdriver for oracle and connection pools?

1094

---

How to create id with auto_increment on oracle?

1033

---

Whether any commands are used for months calculation? If so, what are they?

1135

---

What is a cursor in oracle?

1226

---

What is recovery manager in Oracle?

1105

---

What is an oracle table?

1028

---

Explain drop constraint oracle?

1114

---

how do we code triggers , store procedure , Performance tuning and indexing in a Java Project? Pls kindly get me the perfect answer with the code for each....thank you in advance............pls any body kindly help me soon as possible....

2113

---

What is materialized view in Oracle?

1108

---

What is the dynamic sql in oracle?

1120

---

How to generate query output in html format?

1200

---

What are the differences between number and binary_float in oracle?

1141

---

How would you begin to troubleshoot an ORA-3113 error?

2121

---

If a parameter is used in a query without being previously defined, what diff. exist betw. report 2.0 and 2.5 when the query is applied ?

2332

---

List the parts of a database trigger.

1106

---