List of Examples

• 1-1 Creating the person_typ Object Type
• 1-2 Creating the contacts Table with an Object Type Column
• 1-3 Using the get_idno Object Method
• 1-4 Creating the person_obj_table Object Table
• 1-5 Operations on the person_obj_table Object Table
• 1-6 Using a REF to the emp_person_typ Object
• 1-7 Creating the contacts_ref Table Using a Scoped REF
• 1-8 Using DEREF to Dereference a REF
• 1-9 Obtaining a REF to a Row Object
• 1-10 Creating the people_typ Collection Data Type
• 2-1 Inserting NULLs for Objects in a Table
• 2-2 Creating the employee_typ Object Using a char Qualifier
• 2-3 Creating the office_tab Object Table with a Constraint
• 2-4 Creating the department_mgrs Table with Multiple Constraints
• 2-5 Creating an Index on an Object Type in a Table
• 2-6 Creating a Trigger on Objects in a Table
• 2-7 Using the Dot Notation for Name Resolution
• 2-8 Creating a Member Method
• 2-9 Creating a Map Method
• 2-10 Creating an Order Method
• 2-11 Creating the person_typ Object Type as NOT FINAL
• 2-12 Creating an Object Type as NOT FINAL with a FINAL Member Function
• 2-13 Creating the Parent or Supertype person_typ Object
• 2-14 Creating a student_typ Subtype Using the UNDER Clause
• 2-15 Using Generalized Invocation
• 2-16 Using Generalized Expression
• 2-17 Creating an employee_typ Subtype Using the UNDER Clause
• 2-18 Creating a part_time_student_typ Subtype Using the UNDER Clause
• 2-19 Inserting Values into Substitutable Rows of an Object Table
• 2-20 Creating an Object Type that is NOT INSTANTIABLE
• 2-21 Altering an Object Type to INSTANTIABLE
• 2-22 Resolving PL/SQL Functions With Inheritance
• 2-23 Resolving PL/SQL Functions With Inheritance Dynamically
• 2-24 Inserting Values into Substitutable Columns of a Table
• 2-25 Using OBJECT_VALUE and OBJECT_ID
• 2-26 Creating a Subtype with a Supertype Attribute
• 2-27 Defining Columns of Subtypes that have REF Attributes
• 2-28 Creating a Subtype After Creating Substitutable Columns
• 2-29 Turning off Substitutability When Creating a Table
• 2-30 Constraining Substitutability When Creating a Table
• 2-31 Modifying Substitutability in a Table
• 2-32 Using the CAST Function
• 2-33 Using the DEREF Function
• 2-34 Using the IS OF type Operator to Query Value of a Subtype
• 2-35 Using the REF Function
• 2-36 Using the SYS_TYPEID Function
• 2-37 Using the TREAT Function to Return a Specific Subtype in a Query
• 2-38 Using the TREAT Function to Access Attributes of a Specific Subtype
• 2-39 Using the VALUE Function
• 3-1 Using the Constructor Method to Insert Values into a Nested Table
• 3-2 Creating the department_persons Table Using the DEFAULT Clause
• 3-3 Creating and Populating a VARRAY Data Type
• 3-4 Creating and Populating Simple Nested Tables
• 3-5 Specifying a Different Tablespace for Storing a Nested Table
• 3-6 Specifying LOB Storage for a VARRAY Elements of a Nested Table
• 3-7 Specifying LOB Storage for a VARRAY Type
• 3-8 Increasing the Size of an Element Type in a VARRAY and Nested Table
• 3-9 Increasing the VARRAY Limit Size
• 3-10 Creating a VARRY Containing LOB References
• 3-11 Multilevel Nested Table Storage
• 3-12 Multilevel Nested Table Storage Using the COLUMN_VALUE Keyword
• 3-13 Specifying Physical Attributes for Nested Table Storage
• 3-14 Using Constructors for Multilevel Collections
• 3-15 Nesting Results of Collection Queries
• 3-16 Unnesting Results of Collection Queries
• 3-17 Using a Table Expression Containing a Subquery of a Collection
• 3-18 Using a Table Expression in a CURSOR Expression
• 3-19 Unnesting Queries with Multilevel Collections Using the TABLE Function
• 3-20 Piecewise Operations on Collections
• 3-21 Using VALUE to Update a Nested Table
• 3-22 Using UPDATE to Insert an Entire Multilevel Collection
• 3-23 Piecewise INSERT on a Multilevel Collection
• 3-24 Piecewise INSERT into an Inner Nested Table
• 3-25 Using an Equality Comparison with Nested Tables
• 3-26 Using an IN Comparison with Nested Tables
• 3-27 Testing the SUBMULTISET OF Condition on a Nested Table
• 3-28 Using MEMBER OF on a Nested Table
• 3-29 Using IS NOT on a Nested Table
• 3-30 Using IS A SET on a Nested Table
• 3-31 Determining the CARDINALITY of a Nested Table
• 3-32 Using the MULTISET EXCEPT Operation on Nested Tables
• 3-33 Using the MULTISET INTERSECT Operation on Nested Tables
• 3-34 Using the MULTISET UNION Operation on Nested Tables
• 3-35 Using the POWERMULTISET Operation on Multiset
• 3-36 Using the POWERMULTISET_BY_CARDINALITY Function
• 3-37 Using the SET Function on a Nested Table
• 4-1 Working With Object Types
• 4-2 Declaring Objects in a PL/SQL Block
• 4-3 Null Objects in a PL/SQL Block
• 4-4 Accessing Object Attributes
• 4-5 Inserting Rows in an Object Table
• 4-6 Accessing Object Methods
• 4-7 Updating and Deleting Rows in an Object Table
• 4-8 Updating Rows in an Object Table With a REF Modifier
• 4-9 Using DEREF in a SELECT INTO Statement
• 4-10 Declaring a Nested Table in SQL
• 4-11 Creating a Table with a Varray Column
• 4-12 Varray Constructor Within a SQL Statement
• 4-13 Nested Table Constructor Within a SQL Statement
• 4-14 Performing Operations on PL/SQL Nested Tables With CAST
• 4-15 Using INSERT, UPDATE, DELETE, and SELECT Statements With Nested Tables
• 4-16 Using INSERT, UPDATE, DELETE, and SELECT Statements With Varrays
• 4-17 Using BULK COLLECT with Nested Tables
• 4-18 TEAMS Package Using Dynamic SQL for Object Types and Collections
• 4-19 Calling Procedures from the TEAMS Package
• 5-1 Defining a User-Defined Constructor in C
• 5-2 Mapping SQL Types to Java Classes
• 5-3 Defining a User-Defined Constructor in Java
• 6-1 Creating an Object View
• 6-2 Creating a View with Nested Object Types
• 6-3 Identifying Null Objects in an Object View
• 6-4 Creating a View with a Single-Level Collection
• 6-5 Creating a View with Multilevel Collections
• 6-6 Creating a Reference to Objects in a View
• 6-7 Creating INSTEAD OF Triggers on a View
• 6-8 Creating an Object View to Access Remote Tables
• 6-9 Creating an Object View Hierarchy
• 7-1 SELECT Privileges on Type Access
• 7-2 Creating Dependent Object Types
• 7-3 Using a Type Synonym in a Create Statement
• 7-4 Dropping Type Synonyms
• 8-1 Retrieving Typeids in a Table
• 8-2 Altering an Object Type by Adding and Dropping an Attribute
• 8-3 Altering an Object Type by Adding a Nested Table Attribute
• 8-4 Upgrading Dependent Tables
• 8-5 Converting a Type from FINAL to NOT FINAL
• 8-6 Setting the Attribute Value with the Constructor
• 8-7 Defining and Implementing User-Defined Constructors
• 8-8 Calling User-Defined Constructors
• 8-9 Creating a SQLJ Object
• 8-10 Using SYS.ANYDATA
• 8-11 Partitioning a Table That Contains Objects
• 9-1 Creating Object Types for Columns in a Table
• 9-2 Creating a Table with Column Objects
• 9-3 Creating an Index on Scoped REF Columns
• 9-4 Unnesting a Nested Table with the TABLE Function
• 9-5 Creating the home_phones Function
• 9-6 Using the TABLE Function to Unnest a Query
• 9-7 Using the RETURN AS LOCATOR Clause
• 9-8 Creating an Object Table with a Multilevel Collection
• 9-9 Creating an Object Table Using REFs
• 9-10 Inserting Values into the people_objtab Object Table
• 9-11 Inserting Values into the projects_objtab Object Table
• 9-12 Creating an Object Type with Methods Implemented in Different Languages
• 9-13 Creating an Object Type with a STATIC Method
• 9-14 Creating a Function-Based Index on a Method
• 9-15 Specifying Constraints on an Object Type When Creating a Table
• A-1 Creating the Customer_reltab Table
• A-2 Creating the PurchaseOrder_reltab Table
• A-3 Creating the Stock_reltab Table
• A-4 Creating the LineItems_reltab Table
• A-5 Establish Inventory
• A-6 Register Customers
• A-7 Place Orders
• A-8 Detail Line Items
• A-9 Get Customer and Line Item Data for a Specific Purchase Order
• A-10 Get the Total Value of Purchase Orders
• A-11 Get the Purchase Order and Line Item Data for Stock Item 1004
• A-12 Update the Quantity for Purchase Order 1001 and Stock Item 1534
• A-13 Delete Purchase Order 1001 under the Relational Model
• A-14 Creating the StockItem_objtyp Object
• A-15 Creating the LineItem_objtyp Object
• A-16 Replacing the LineItem_objtyp Object
• A-17 Creating the PhoneList_vartyp Type
• A-18 Creating the Address_objtyp Object
• A-19 Creating the Customer_objtyp Object
• A-20 Creating the LineItemList_ntabtyp Type
• A-21 Creating the PurchaseOrder_objtyp Object
• A-22 Creating the PurchaseOrder_objtyp Type Body
• A-23 Creating the Customer_objtyp Type Body
• A-24 Creating the Customer_objtab Table
• A-25 Creating the Stock_objtab Table
• A-26 Creating the PurchaseOrder_objtab Table
• A-27 Replacing the PurchaseOrder_objtyp Type Body
• A-28 Adding the SCOPE FOR Constraint
• A-29 Inserting Values in Stock_objtab
• A-30 Inserting Values in Customer_objtab
• A-31 Inserting Values in PurchaseOrder_objtab
• A-32 Inserting Values in LineItemList_ntab
• A-33 Inserting Values in PurchaseOrder_objtab and LineItemList_ntab
• A-34 Query Purchase Orders
• A-35 Query Customer and Line Item Data for Purchase Order 1001
• A-36 Query Total Value of Each Purchase Order
• A-37 Query Purchase Order and Line Item Data for Stock Item 1004
• A-38 Query Average Discount across all Line Items of all Purchase Orders
• A-39 Delete Purchase Order 1001 in an Object-Relational Model
• A-40 Create PurchaseOrderList_ntabtyp
• A-41 Alter Customer_objtyp
• A-42 Add SCOPE for REF to Nested Tables
• A-43 Update Customer_objtab
• A-44 Insert Purchase Orders into Customer_objtab
• A-45 Alter PurchaseOrder_objtyp
• A-46 Insert into LineItemList_ntabtyp with VALUE()
• A-47 Query Customer_objtab for Customer John Nike
• A-48 Query Customer_objtab Using TABLE Expression
• A-49 Query Customer_objtab for Purchase Order 1020
• A-50 Create Corp_Customer_objtyp
• A-51 Insert Data for Ordinary Customer
• A-52 Insert Data for Corporate Customer
• A-53 Insert Purchase Order for Ordinary Customer
• A-54 Insert Purchase Order for Corporate Customer
• A-55 Selecting All Corporate Customers and Their Subtypes
• A-56 Selecting All Corporate Customers with No Subtypes
• A-57 Selecting PONo Just for Corporate Customers
• A-58 Selecting a Subtype Attribute Using the TREAT Function
• A-59 Selecting a Subtype Attribute Without the TREAT Function
• A-60 Discovering the Type of Each Instance