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
What are the ansi data types supported in oracle?
Why packages are used in oracle?
How to assign values to variables?
What are the logical operations?
What is Undo Management Advisor in Oracle?
how can db_files > maxdatafiles since db_files is for instance and the later is for database
What is raw datatype in oracle?
What is not equal to in oracle?
Explain alias?
how to join query for one source type is oracle another source type is sql server ?
How many types of cluster table in Oracle?
Why should I use oracle database?
What is a tns file?
1) Does oracle have any table which contain all the exceptions and it's code internally?
How do I reset a sequence in oracle?