Interested to Buy Any Domain ? << Click Here >> for more details...
how to we delete a row using varray
- 3 Answers
- 4671 Views
- CTC, I also Faced
- E-Mail Answers
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 |
Differentiate the standard purchase order,Blanket purchase agreement,Contract purchase agreement,Planned purchase order?
Why does for update in oracle 8 cause an ora-01002 error?
What are the numeric comparison operations?
What are the execution control statements?
How to recover a dropped index?
What are the parameters that we can pass through a stored procedure?
What is the recommended interval at which to run statspack snapshots, and why?
How to do a full database export?
What is raw datatype?
Does a Before form trigger fire when the parameter form is suppressed ?
How to execute the package in oracle?
What are the various constraints used in oracle?
Oracle General 
