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.
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Explain the use of inctype option in exp command.
Will you be able to store pictures in the database?
What is a table index?
Explain mutating triggers.
Is there an oracle sql query that aggregates multiple rows into one row?
In Oracle Clinical 4.5.0, can the VIEW_TEMPLATE_ID column in DATA_EXTRACT_VIEWS table contain NULL value?
Does oracle charge for java?
What is key preserved table?
What do you mean by group by clause?
can anyody please send me the dump for Oracle 10g certifications for DBA path?
What is the difference between translate and replace?
how to clone 9i Database on to 10g Database.
Describe the types of sub query?
How to display row numbers with the records?
What is a subquery?