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 use of prepared statement?

749


what is single byte over head in oracle..?

2093


Can we use rowid as primary key?

738


What are the different types of joins in sql?

1153


Differentiate between % rowtype and type record.

923






What is sqlservr exe?

699


What action do you have to perform before retrieving data from the next result set of a stored procedure ?

2302


What is using in sql?

796


Can you have more than one key in a database?

690


What is relationship? How many types of relationship are there?

791


how to get @@error and @@rowcount at the same time? : Sql dba

743


Does execute immediate commit?

931


What is pivot in sql?

670


What is view explain with example?

688


What is delimiter sql?

705