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 |
Hi all, Can any one give answer for this question. Suppose im having employee table with fields, eno, ename, dept, address1, address2, address3. In address field employee can fill only address1 or address2 or address3... at a time he can fill three address fields. now i want all employee names who filled only one address field.. Plz its urjent can any one give querry.. Thanks in advance.
A VIEWS takes memory in the database. If yes, how can u proove it? is there any way to display the size of views?
How a database is related to tablespaces?
How to use "in" parameter properly?
how to do daily transactions with out sql* loader control file regesterd in apps?
What happens if you set the sga too low in oracle?
How to select oracle sequence from different schema and How to select oracle sequence from different Databases. Explain with example
Can select statements be used on views in oracle?
What is sharded cluster?
How to manage transaction isolation level?
What is the Extension of Oracle Database? As extension of Access Database is .mdb
what's query optimization and without use of IN AND Exist can we get another way data from query