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
Explain the structure of pl/sql in brief.
What do you understand by case manipulation functions?
How do I run sql profiler?
What is the use of count (*) in sql?
How do sql triggers work?
What is cost in sql execution plan?
What is sql key?
What is parallel hint?
what is a scheduled jobs or what is a scheduled tasks? : Sql dba
what are the different type of sql's statements ? : Sql dba
what is online transaction processing (oltp)? : Sql dba
How can we store rows in PL/SQL using array?
Does truncate table reset auto increment?
What is dml statement?
How do I save a stored procedure?