Interested to Buy Any Domain ? << Click Here >> for more details...
how to we delete a row using varray
- 3 Answers
- 4675 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 are the types of partitions in oracle?
How to load data from external tables to regular tables?
What is a nested table and how is it different from a normal table?
What is blob data type in oracle?
How do you get nicely formatted results from an oracle procedure that returns a reference cursor?
What is an oracle recycle bin?
How to Remove the 3rd highest salary person record from table?
How to pass a parameter to a cursor in oracle?
How to generate query output in html format?
What is connection pooling in oracle?
How can I get column names from a table in oracle?
What is oracle thin client?
Oracle General 
