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 drop an index in oracle?
How to create lov dynamically at runtime & attach to text field?
How to sort output in descending order in oracle?
Does oracle database need java?
What are the different types of database objects?
What are advantages of dateset in datastage?
what is the syntax of INSERT command?
How to run create database statement again?
How do I know if oracle is installed on windows?
Can sub procedure/function be called recursively?
hi friends i completed b.com 2004.i have 3y accounting exp. in manufacturing company.now i have completed oracle finance.pls suggest me how will get job in oracle.can i get job in oracle.
what is the syntax of DROP command?