Interested to Buy Any Domain ? << Click Here >> for more details...
how to we delete a row using varray
- 3 Answers
- 4636 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 |
Explain the use of control file?
What is the recommended interval at which to run statspack snapshots, and why?
What is difference between a formal and an actual parameter?
What types of joins are used in writing subqueries?
How do you find out from the RMAN catalog if a particular archive log has been backed-up?
Please explain drop constraint oracle?
What is oracle database client?
how to get the no employee in each department including the dept which has 0 employee
17. Display the order number and average item cost for each order.
How to convert times to characters in oracle?
what is the use of ondelete cascade?
Can any one explain me when i execute below query.. select months_between('07-JUL-12','10-FEB-12') from dual; Out put:- 4.90322581 How oracle calculate?
Oracle General 
