Main diff between varray and nested tablea
Answer Posted / prabu t
Varray -
Can be stored in the database.
Bounded (maximum length should be given).
Delete / Remove values only from the end.
Nested Tables -
Cannot be strored in the database.
Unbounded (No maximum length).
Delete / Remove values anywhere in the table.
| Is This Answer Correct ? | 7 Yes | 8 No |
Post New Answer View All Answers
Can we use threading in pl/sql?
Is it possible to include an insert statement on the same table to which the trigger is assigned?
Why partition by is used in sql?
what is the command used to fetch first 5 characters of the string? : Sql dba
How exception handling is done in advance pl/sql?
Why does sql need a server?
How can you create an empty table from an existing table?
Explain ttitle and btitle.
Write a sql query to find the names of employees that begin with ‘a’?
what is index? : Sql dba
What are all the different types of indexes?
which operator is used in query for pattern matching? : Sql dba
what is the command line end user interface - mysql? : Sql dba
Does inner join return duplicate rows?
How to rename a column in the output of sql query?