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

WHT ARE THE AGGREATE FUNCTIONS?

7 Answers   GEITC, TCS,


What is a schema in oracle?

0 Answers  


Hi All, Recently I attended a interview for a developer position in an educational university. They asked me the a question, I answered somehow but I was not not satisfied myself. Can anybody reply for it? The question is: A business user comes to you directly with an urgent request:: there is a problem with some students not being able to re-enrol. It appears that ?something has gone wrong with the end-dating of some previous courses they had enrolled in, and this is preventing them from completing their on-line re-enrolments?. Fortunately the user has done some analysis on the situation, and has developed some code to change the end dates. They tell you that they have tested this code in the ?dev? environment, and it works fine. They are asking you to please get this implemented in production as soon as possible. What steps would you take in response to their request ? Thanks

2 Answers  


diff between DELETE and TRUNCATE?.

14 Answers   HCL, Yalamanchili Software,


I have two tables : COuntry,city I want all the cities in each country.Question on Cross Join.

3 Answers   Microsoft,


candidate key is subset of super key but not vice-verse explain

0 Answers  


What is oracle host variable?

0 Answers  


If a table column has is UNIQUE and has NOT NULL, is it equivalent to a PRIMARY KEY column?

7 Answers   IBM,


What is meant by joins?

0 Answers  


what is null value?

11 Answers   KITS, Oracle,


What do database buffers contain?

0 Answers  


How to invoke the data pump export utility?

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)