Answer Posted / dinesh

Type CC is Varray(5) of number;
c CC:=CC(1,2,3,4,5);
Begin
c.trim /* Delete last 5th Element with thier place holder from varray*/
c.trim(3)/*remove last 3 element with thier place holder from varra
c.delete/* delete all the varray.

WHAT IS ecc 6.0

2145

---

How to divide query output into groups in oracle?

981

---

What is an oracle and why it is used?

1138

---

What is dual table oracle?

978

---

How to create a testing table in oracle?

984

---

How to assign query results to variables?

1040

---

What is a synonym? What are its various types?

1104

---

What is the data type of dual table?

987

---

Can we connect to ORACLE db using Windows Authentication?

1235

---

How to loop through data rows in the implicit cursor?

1063

---

How many categories of data types in oracle?

1020

---

what are bitmap indexes? How does they work?

2232

---

How to turn on or off recycle bin for the session?

1100

---

How to start instance with a minimal initialization parameter file?

1031

---

Explain how are indexes update?

1058

---