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.

How to define an external table with a text file?

1076

---

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

1086

---

what is Single Byte Overhead...?

2561

---

What is the difference between truncate & delete command?

1189

---

what is difference between sql plus and sql*plus? (not sql and sql plus).

3905

---

Is it possible to split the print reviewer into more than one region ?

2281

---

What are the common oracle dba tasks?

1153

---

Explain the use of record length option in exp command.

1067

---

How can you tell how much space is left on a given file system and how much space each of the file systems subdirectories take-up?

2829

---

How to change user password in oracle?

1034

---

How to convert a date to char in oracle? Give one example.

1073

---

What is bulk collect in oracle?

1000

---

ur a sql devoloper...what is the process in ur company for finding the database BUGS .. seperate DB testers are there? or devr.s are manage? if DB TESTERS in there what is the process

2290

---

What privilege is needed for a user to query tables in another schema?

974

---

When do you get a .pll extension in oracle? Explain its importance

1045

---