Interested to Buy Any Domain ? << Click Here >> for more details...
how to we delete a row using varray
- 3 Answers
- 4776 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 |
what is the syntax of ALTER command?
Can multiple columns be used in group by in oracle?
What happens if the update subquery returns multiple rows?
What is the difference between INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN?
hai, when to use char and varchar2....?
Shall I get Pro*C Compiler in Oracle-10g release ?
What is Database Buffers ?
how to genarate random numbers in oracle for particular row?
State and explain the different types of data models?
9. Display the client name and order date for all orders using the JOIN . . . USING method.
How to define a variable to match a table column data type?
How to retrieve first and last records from a table?
Oracle General 
