how to we delete a row using varray
- 3 Answers
- 3581 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 difference between postgresql and oracle?
7. Repeat query (7) but also display all clients who have never ordered anything.
Please explain joins in oracle?
What is a public synonym?
What is the usage of merge statement?
How to connect the oracle server as sysdba?
hai, when to use char and varchar2....?
How do you rate yourself in oracle and sql server ?
Explain the use of tables option in exp command.
4. Using a set operator, display the creditor number of all creditors who have ever been paid.
How to create index-by table in oracle?
what is the difference between authorization and authentication?
Oracle General 
