List of Examples

• 2-1 CREATE TABLE employees
• 2-2 ALTER TABLE employees
• 2-3 Rows in the employees Table
• 2-4 ROWID Pseudocolumn
• 2-5 Object Type
• 2-6 Object Table
• 2-7 Rows in Departments Table
• 2-8 Indexed Cluster
• 2-9 Hash Cluster
• 3-1 Composite Index Entries
• 3-2 Index Entries in Orders Table
• 3-3 Query of customers Table
• 3-4 Join of employees and jobs Tables
• 3-5 Query Containing an Arithmetic Expression
• 4-1 Sample Row Set for Partitioned Table
• 4-2 Range-Partitioned Table
• 4-3 List-Partitioned Table
• 4-4 Hash-Partitioned Table
• 4-5 Local Partitioned Index
• 4-6 Global Partitioned Index
• 4-7 Join View
• 4-8 Public Synonym
• 4-9 Public Synonym
• 5-1 Unique Constraint
• 7-1 DDL Statements
• 7-2 Sample Join
• 7-3 Subquery
• 7-4 Execution Plan for SELECT with FIRST_ROWS Hint
• 7-5 Execution Plan for SELECT with No Hint
• 7-6 Execution Plan
• 8-1 PL/SQL Procedure
• 8-2 PL/SQL Package
• 8-3 lineitems_trigger
• 12-1 ROWID Pseudocolumn
• 12-2 Rows in sales Table
• 12-3 OLTP Compressed Rows in sales Table
• 13-1 Creation of ADR
• 14-1 Query Plan for Table Join
• 15-1 One Connection with Two Sessions
• 15-2 Connection with No Sessions
• 19-1 XMLType