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 enter substitution variable in oracle?

984

---

What is the difference between Delete, Truncate and Drop in Oracle?

1067

---

What is a select query statement in oracle?

901

---

List the various oracle database objects?

996

---

How a database is related to tablespaces?

987

---

Is primary key indexed by default in oracle?

931

---

Can multiple cursors being opened at the same time?

1018

---

Write a trigger example in oracle?

983

---

What is the difference between online and offline backups?

973

---

What is a oracle database?

996

---

How to rename a tablespace in oracle?

1035

---

What are the differences between char and varchar2 in oracle?

1076

---

What is an external table?

959

---

Explain the use of owner option in exp command.

994

---

What is an oracle transaction?

1054

---