Answer / kesava

COLLECTION:
Collection contains number of user defined types which is
stored number of data items in Single unit.
Why introduce Collection:
--->When ever we are using cursor memory area control does not get it back from Active set Area.
=====>when ever we are using Collection we are operating
element and also we are moving forward and reverse directions with in memory are using Collection
collection Types:
index by Table
Nested Table
Varray

What is Highwatermark?

3 Answers   Thermotech,

---

I have 2 table A and B. In A 1 lakh record is present. In b 20 thousand data is present. To get the unique data from table A and B which join we should prefer left inner join or right outer join. Please answer.

4 Answers   GE,

---

What is meant by temporal data?

0 Answers  

---

What is the advantage of index in sql?

0 Answers  

---

What is difference between stored procedure and trigger?

0 Answers  

---

what is the command for user data type?

2 Answers  

---

What is an implicit commit?

0 Answers  

---

Can we connect to postgresql using sql developer?

0 Answers  

---

What is user define exception and example

1 Answers   HP, KP,

---

What plvcmt and plvrb does in pl/sql?

0 Answers  

---

What are conditional predicates?

0 Answers  

---

What is the maximum number of triggers,can apply to a single table?

2 Answers  

---