As a result, SQL joins are not required to retrieve data from multiple objects. OIDs create data relationships by using the embedded pointers to point to other objects. As a result, the addition of a new OID will require the DBA to scan each object affected in the database. When the object is deleted, the programmers must know what objects have OIDs that contain the address of the deleted object. You refer to the objects that appear as rows of object tables by using their object identifiers.
Applications are able to use references to navigate among the objects.
Oracle8 allows a column of a table or element of a collection to contain OIDs. You can obtain a REF to a row object by selecting the object from its object table and applying the REF operator. OID access is much faster than table joins. You are able to establish relationships between tables without using foreign keys. Repeating Groups Application developers have used arrays for some time.