how to we delete a row using varray

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is a procedure in oracle?

775


What is oracle open database communication (odbc)?

747


What is set operator oracle?

711


What is MTTR advisor in Oracle?

824


What is SQL access advisor in Oracle?

843


Explain the difference between sql and oracle?

822


How to speed up webrick?

818


What is instant client oracle?

770


What are the different types of database objects?

723


Can we write dml statement in function in oracle?

812


What is Reduced List of Values?

1883


What is a read only transaction in oracle?

795


why should i declare foreign key constraint as self relation instead of binary relation in tables ?

1786


Explain an integrity constrains?

878


What is Redo Log Buffer in Oracle?

821