why should required nested tables, Object types, partition
tables and varying arrays. what is the difference between
these are all. give me example with explanation.

Answer Posted / suresh kumar somayajula

V-Array is an Ordered set of elements.It's having Maximum
size and you can't delete individual elements. V-Arrays are
dense.

Nested Table is an un-orderes set of elements.It doesn't
have maximum size and you can delete individual elements
from Nested Tables . Nested Table can be Parse.

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 the primary use of normalization?

524


define sql update statement ? : Sql dba

570


Is primary key clustered or nonclustered?

556


what are null values? : Sql dba

542


What are different types of keys?

521






What is an oracle stored procedure?

586


Is truncate ddl or dml?

541


What is the difference between null value, zero, and blank space?

556


What is partition in sql query?

515


what are integrity rules?

568


What is a record in pl/sql?

547


What is difference between sql function and stored procedure?

503


Does sql support programming?

553


What is a mutating table and a constraining table?

569


Is join same as left join?

527