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

Differences between UNIQUE and DISTINCT in select statements

26 Answers   ABS, DELL, Deloitte, Hewitt, Oracle, Verinon Technology Solutions, Wipro,

---

Mention what does plvtab enables you to do when you showthe contents of pl/sql tables?

0 Answers  

---

Why self join is used in sql?

0 Answers  

---

what is the forward decleration in packages?

1 Answers  

---

What is meant by <> in sql?

0 Answers  

---

How do I write a sql query in pgadmin 4?

0 Answers  

---

what are the limitations of mysql in comparison of oracle? Mysql vs. Oracle. : Sql dba

0 Answers  

---

Why does %isopen return false for an implicit cursor?

1 Answers  

---

How can one get sql*loader to commit only at the end of the load file? : aql loader

0 Answers  

---

What is pseudo column ?

6 Answers   ABB,

---

how to give permission to users that users can update/insert/delete on a row of table on timeing 10am to 6pm only?

4 Answers   TCS,

---

What is the difference between alter trigger and drop trigger statements?

0 Answers  

---