Interested to Buy Any Domain ? << Click Here >> for more details...
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.
- 2 Answers
- 6669 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
Are stored procedures faster than queries?
What is foreign key sql?
What is bind reference and how can it be created?
hi this is nakka i have been looking for 1+ exp in oracle sql,plsql developer positions also have knoledge on d2k i am not getting proper walkins how to know it? where can i find it?
what is the stuff function and how does it differ from the replace function? : Sql dba
What is the difference between local variables and global variables?
how can we find the number of rows in a table using mysql? : Sql dba
What does cursor do in sql?
What does the argument [or replace] do?
Is grant a ddl statement?
What is pl sql variable?
What can be a size of a pl/sql block? Is there any limit?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
