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
Can you have more than one content canvas view attached with a window ?
Can we create database in oracle using command line ?
Can we use bind variables in oracle stored procedure?
Difference between the “verify” and “feedback” command?
How can Oracle users be audited?
What are the limitations oracle database 10g xe?
How to get a create statement for an existing table?
Where are the settings stored for each instance in oracle?
A table t is there.If you perform insert ,update and delete then the trigger will fire.What is the minimum no of trigger required for a table.
How to insert a record into a table?
What is memory advisor in Oracle?
Write a trigger example in oracle?
can anyody please send me the dump for Oracle 10g certifications for DBA path?
How to define default values for formal parameters?
Why does oracle 9i treat an empty string as null?
