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 / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

Mention what plvcmt and plvrb does in pl/sql?

834


What are types of joins?

703


Which is better varchar or nvarchar?

732


Why select is used in sql?

691


What is implicit cursor in pl sql?

739






What is partition in sql query?

719


What is pl sql quora?

821


What is a variable in sql?

725


Under what condition it is possible to have a page level lock and row lock at the same time for a query? : Transact sql

744


what is schema? : Sql dba

740


What is thread join () in threading?

735


What is left join in sql?

751


how can we optimize or increase the speed of a mysql select query? : Sql dba

689


What are the two types of cursors in pl sql?

733


How does a covering index work?

693