|
|
| |
 |
|
Using Object IDs (OIDs)
in Oracle 8
Oracle Tips by Mike Ault |
Summary
In this paper I have discussed the definition of
an Object ID (OID) shown how they are used and discussed their
limitations. Through script listings we have seen how to insert,
update, delete and query using REF, DEREF and VALUE functions
against an OID. OIDs are bringing pointers back into the database
realm. In some cases OIDs will speed access to data in others they
will add to the level of complexity in our applications. We must
take care to use them wisely.
SEE CODE DEPOT FOR FULL SCRIPTS
 |
For more information on this topic, I recommend Don
Burleson's latest book "Oracle
Tuning: The Definitive Reference".
You can buy it direct from the publisher for 50%-off and get
instant access to the code depot of Oracle tuning scripts: |
http://www.rampant-books.com/book_1002_oracle_tuning_definitive_reference_2nd_ed.htm
 |
Expert Remote DBA
BC is America's oldest and largest Remote DBA Oracle support
provider. Get real Remote DBA experts, call
BC Remote DBA today. |
 |
|
|
|
|
