how to we delete a row using varray
Answers were Sorted based on User's Feedback
Answer / ganga
We can't delete records from varray by using delete method.
Is This Answer Correct ? | 2 Yes | 0 No |
Answer / dinesh
Yes we can not delete single element from varray using DELETE method but we can delete last element from VArray using TRIM method
means if your varray name is V1 then
V1.trim delete last element from varray.
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / 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 |
How to increment dates by 1 in oracle?
Explain the difference between sql and oracle?
What are the major difference between truncate and delete?
does Oracle has only one table space?
What are the type of Synonyms?
What are privileges and grants?
What is an oracle data file?
How to write date and time interval literals in oracle?
How to define an anonymous block?
Where are the settings stored for each instance in oracle?
How to select the name of employee who is getting maximum sal with out using subquery
What is where clause in oracle?