Interested to Buy Any Domain ? << Click Here >> for more details...
how to we delete a row using varray
- 3 Answers
- 4689 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 |
How to define an external table with a text file?
How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?
Is it possible to split the print reviewer into more than one region ?
Is oracle a programming language?
What is a sub query and what are the different types of subqueries?
What is an Integrity Constrains ?
What is an Extent ?
how to get the index id?
what is partitioning? Types of partitioning. explain? what is the new kind of partitioning type introduced in 9i?
How is it different from a normal table?
can u call user defined functions in select statements
What are the factors that affect OPTIMIZER in choosing an Optimization approach ?
Oracle General 
