how to we delete a row using varray
- 3 Answers
- 3805 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 get a create statement for an existing table?
Use of an integrity constraint is better to validate data. Explain
What are the restrictions in a oracle read only transaction?
Can we call a trigger inside a function and function inside a trigger? Give example.
How to shutdown your 10g xe server?
How to call a stored function in oracle?
SELECT THE RECORDS FROM 3 TABLES LIKE(T1,T2,T3) AND HOW CAN WE INSERT THAT RECORD IN ANOTHER TABLE LIKE(T4)?
Is it possible to set second Primary Key Constraint in a table in Oracle Database ?
What is a sub query? What are its various types?
what is the syntax of ALTER command?
Display Odd/ Even number of records?
How to define a variable to match a table column data type?
Oracle General 
