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.

Answers were Sorted based on User's Feedback



why should required nested tables, Object types, partition tables and varying arrays. what is the ..

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

why should required nested tables, Object types, partition tables and varying arrays. what is the ..

Answer / manoranjan sethy

If you want to declare fixed element then use varray.
If you want to declare any number of element at run time then use nested table.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL PLSQL Interview Questions

what is a constraint? : Sql dba

0 Answers  


how many sql ddl commands are supported by 'mysql'? : Sql dba

0 Answers  


What does partition by mean in sql?

0 Answers  


Is sql better than excel?

0 Answers  


Does pdo prevent sql injection?

0 Answers  






What is a database? Explain

0 Answers  


what is overloading procedure or overloading function ?

3 Answers   Genpact,


What packages(if any) has oracle provided for use by developers?

1 Answers  


What is string data type in sql?

0 Answers  


What is raid? How does it help storage of databases?

0 Answers  


What is compound trigger?

0 Answers  


Why join is faster than subquery?

0 Answers  


Categories