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
- 6535 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 |
Can we want to pass a parameter payroll_id to this external pl/sql function, how do we do it?
What is trigger types of trigger?
How many sectors are in a partition?
Is it possible to create startup or shutdown trigger for on-schema?
What are the set operators in sql?
I need a function for a train ticket reservation please answer it thanks in advance
How to return more than one value from a function?
How packaged procedures and functions are called from the following?
What is union, minus and interact commands?
What is sqlerrd?
Why we use joins in sql?
What do you understand by pl/sql records?
-
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)
