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 |
write a query to dispaly those name who is more than one in student table? example- in a student table sandeep kumar comes 4 times, rakesh kumar comes 2 times, ajit kumar comes 1 times so query will display sandeep kumar and rakesh kumar single times.
what is main def between plsql/table and array?
What is Database Link ?
Youre getting high busy buffer waits - how can you find whats causing it?
How to get execution path reports on query statements?
How to write date and time literals in oracle?
Can we create trigger on view in oracle?
What is user managed backup in Oracle?
How can we Update a table with out using UPDATE command?
What is ceil and floor in oracle?
wirte the syntax of update query?
what is the syntax of INSERT command?