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.

Explain view?

991

---

What is sharded cluster?

962

---

How to list all tables in your schema?

1006

---

What is Virtual Private Database in Oracle?

1034

---

Explain oracle’s system global area (sga).

1099

---

How to invoke the original export import utilities?

1006

---

What is a sub query and what are the different types of subqueries?

1089

---

How to connect asp pages to oracle servers?

1027

---

What is Library Cache in Oracle?

1094

---

How to create an oracle testing table?

1021

---

how to use select statement as formal parameter in procedure specification?(someone said that using string) ex:-procedure(a in number,select ename from emp ) i am asking syntax like this?

1965

---

What is the oracle implicit cursor?

1021

---

How to run the anonymous block again?

1084

---

Can we write dml statement in function in oracle?

1046

---

Design database draw er diagram for a certain scenario ?

4550

---