how to we delete a row using varray

Answers were Sorted based on User's Feedback



how to we delete a row using varray..

Answer / ganga

We can't delete records from varray by using delete method.

Is This Answer Correct ?    2 Yes 0 No

how to we delete a row using varray..

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

how to we delete a row using varray..

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

Post New Answer

More Oracle General Interview Questions

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.

4 Answers   JPMorgan Chase,


A VIEWS takes memory in the database. If yes, how can u proove it? is there any way to display the size of views?

1 Answers   IBM,


How a database is related to tablespaces?

0 Answers  


How to use "in" parameter properly?

0 Answers  


how to do daily transactions with out sql* loader control file regesterd in apps?

0 Answers   Arrow Electronics,


What happens if you set the sga too low in oracle?

0 Answers  


How to select oracle sequence from different schema and How to select oracle sequence from different Databases. Explain with example

1 Answers   Polaris,


Can select statements be used on views in oracle?

0 Answers  


What is sharded cluster?

0 Answers  


How to manage transaction isolation level?

0 Answers  


What is the Extension of Oracle Database? As extension of Access Database is .mdb

2 Answers  


what's query optimization and without use of IN AND Exist can we get another way data from query

0 Answers  


Categories
  • Oracle General Interview Questions Oracle General (1808)
  • Oracle DBA (Database Administration) Interview Questions Oracle DBA (Database Administration) (261)
  • Oracle Call Interface (OCI) Interview Questions Oracle Call Interface (OCI) (10)
  • Oracle Architecture Interview Questions Oracle Architecture (90)
  • Oracle Security Interview Questions Oracle Security (38)
  • Oracle Forms Reports Interview Questions Oracle Forms Reports (510)
  • Oracle Data Integrator (ODI) Interview Questions Oracle Data Integrator (ODI) (120)
  • Oracle ETL Interview Questions Oracle ETL (15)
  • Oracle RAC Interview Questions Oracle RAC (93)
  • Oracle D2K Interview Questions Oracle D2K (72)
  • Oracle AllOther Interview Questions Oracle AllOther (241)