Index by table
|
Nested table
|
Varray
|
1. This is unconstraint table
|
This is an unconstraint table
|
This is an constraint table
|
2. Not to store permanently In database table
|
To store permanently into database using SQL
|
To store permanently into database using SQL
|
3. We cannot add or remove Indexes
|
we can add or remove indexes using extend, trim
collection Method
|
we can add or remove indexes using extend trim
collection method
|
4.Exists, first, last, prior,Count, next,
delete,Delete (element1, Element n)
|
Extend, trim, exists, first, last,prior, next,
delete, count,delete (element1, element n)
|
Limit, extend, trim, exists,first, last, prior,
next, count,delete
|
5. Indexes range from -ve to +ve
|
Indexes start with 1
|
Indexes starts with 1
|
Home » PL/SQL » Difference among Index by table, Nested table and Varray
Sunday, 26 March 2017
Difference among Index by table, Nested table and Varray
Subscribe to:
Post Comments (Atom)
Exactly where and why we use collections?
ReplyDeletewhere we use associative array?
where we use nested table?
where we use varrays?
pls add this article also.....
Hi Krishna,these article already added please check left sidebar you can find articles
DeleteOracle Apps R12 and Oracle Fusion Cloud Self Paced Online Training Videos Published on Udemy with Life Time Access & Live Meeting Support to Clear your Queries. Avail 25% to 80% discount. Please Check https://www.oracleappstechnical.com for Never Before Offers and Discount Coupon Codes.
ReplyDeleteAmong the different schools offering a course on game designing is the ITT Technical Institute. among us impostor guide
ReplyDelete