Contents
- Audience
- Organization
- Related Documentation
- Conventions
- Documentation Accessibility
- Oracle Database Architecture
-
- Over
view of Oracle Grid Architecture - XXX
-
- Oracle Technologies that Enable the Grid
- Managing the Grid
- Overview of Applicatio
n Architecture
-
- Client/Server Architecture
- Multitier Architecture: Application Servers
- Overview of Physical Database Stru
ctures
-
- Datafiles
- Control Files
- Redo Log Files
- Archive Log Files
- Parameter Files
- Alert and Trace Log Files
- Backup Files
- Overview of Logical Database Structures
-
- Tablespaces
- Oracle Data Blocks
- Extents
- Segments
- Overv
iew of Schemas and Common Schema Objects
-
- Tables
- Indexes
- Views
- Clusters
- Synonyms
- Overview of the Oracle Data Dictionary
- Overview of the Oracle Instance
-
- Real Applicatio
n Clusters: Multiple Instance Systems
- Instance Memory Structures
- System Global Area
- Program Global Area
- Oracle Background Processes
- Process Architecture
- Overview of Accessing the Database
-
- Network Connections
- Starting Up the Database
- How Oracle Works
- Overview of Oracle Utilities
- Oracle Data
base Features
-
- Overview of Scalability and Performance Features
-
- Concurrency
- Read Consistency
- Locking Mechanisms
- Quiesce Database
- Real Application Clusters
- Portability
- Overview of Manageability Features
-
- Self-Managing Database
- <
a href="intro.htm#sthref144">Oracle Enterprise Manager
- SQL*Plus
- Automatic Storage Management
- The Scheduler
- Database Resource Manager
- Overview of Database Backup and Recovery
Features
-
- Types of Failures
- Structures
Used for Recovery
- Overview of High Availability Features
- Overview of Business Intelligence Features
-
- Data Warehousing
- Extraction, Transformation, and Loading (ETL)
-
Materialized Views
- Bitmap Indexes in Data Warehousing
- Table Compression
- Parallel Execution
- Ana
lytic SQL
- OLAP Capabilities
- Data Mining
- Partitioning
- Overview of Content Management
Features
-
- XML in Oracle
- LOBs
- Oracle Text
- Oracle Ultra Search
- Oracle interMedia
- Oracle Spatial
- Overview of Security Features
-
- Security Mechanisms
- Overview of Data Integrity and Triggers
-
- Integrity Constraints
- Keys
- Triggers<
/dd>
- Overview of Information Integration Features
-
- Distributed SQL
- Oracle Streams
- Or
acle Transparent Gateways and Generic Connectivity
- Oracle Database App
lication Development
-
- Overview of Oracle SQL
-
- SQL Statements
- Overview of PL/SQL
-
- PL/SQL Program Units
- Overview of Java
- Overview of Application Programming Languages (APIs)
- Overview of
Transactions
-
- Commit and Undo Transactions
- Savepoints
- Overview of Datatypes
- Overview of Globalization
- Introduction to Data B
locks, Extents, and Segments
- Overview of Data Blocks
-
- Data Block Format
-
- Header (Common and Variable)
Table Directory
- Row Directory
- Overhead
- Row Data
- Free
Space
- Free Space Management
-
- Availability and Optimization of Free Space in a Data Block
- Row Chaining and Migra
ting
- PCTFREE, PCTUSED, and Row Chaining
-
- The PCTFREE Parameter
- The PCTUSED Parameter
Overview of Extents
- When Extents Are All
ocated
- Determine the Number and Size of Extents
- How Extents Are Allocated
- When Extents Are Deallocated
-
- Extents in Nonclustered Tables
- Extents in Clustered Tables
- Extents in Materialized Views and Their Logs
-
Extents in Indexes
- Extents in Temporary Segments
- Extents in Rollback Segments
Overview of Segments
- Introduction to Data Segments
- Introduction to
Index Segments
- Introduction to Temporary Segments
-
- Operations that Require Temporary Segments
- Segments in Temporary Table
s and Their Indexes
- How Temporary Segments Are Allocated
- Introduction to Automatic Undo Management
-
- Undo Mode
- Undo Quota
- Automatic Undo Retention
- External Views
- Introduction to Tablespaces, Datafiles, and Control Files
-
- Oracle-Managed Files
- Allocate More Space for a Database
- Overview of Tablespaces
-
- Bigfile Tablespaces
-
- Benefits of Bigfile Tablespaces
- Co
nsiderations with Bigfile Tablespaces
- The SYSTEM Tablespace
-
- The Data Dictionary
- PL/SQL Program Units Descrip
tion
- The SYSAUX Tablespace
- Undo
Tablespaces
-
- Creation of Undo Tablespaces
- Assignment of Undo Tablespaces
- Default Temporary Tablespace
-
- How to Specify a Default Temporary Tablespace
- Using Multiple Tablespaces
- Managing Space in Tablespaces
- Locally Managed Tablespaces
- Segment Space
Management in Locally Managed Tablespaces
- Dictionary Managed Tablespaces
<
/dd>
- Multiple Block Sizes
- Online and Offline Table
spaces
-
- Bringing Tablespaces Offline
- Use of Tablespaces for Special Procedures
- Read-Only Tablespaces
- Temporary Tablespaces for Sort Operations
-
- Sort Segments
- Creation of Temporary Tablespaces
- Transport of Tablespaces Between Databases
-
- How to Move or
Copy a Tablespace to Another Database
- Overview of Datafiles
-
- Datafile Contents
- Size of Datafiles
- Offline Datafiles
- Temporary Datafiles<
/dd>
- Overview of Control Files
-
- Control File Contents
- Multiplexed Control Files
- Introduction to Transactions
-
- Statement
Execution and Transaction Control
- Statement-Level Rollback
- Resumable Space Allocation
- Overview of Transaction Managem
ent
-
- Commit Transactions
- Rollbac
k of Transactions
- Savepoints In Transactions
- Transaction Naming
-
- How Transactions Are Named
- Commit Comment
- The Two-Phase Commit Mechanism
- Overview of Autonomous Transactions
-
- Autonomous PL/SQL Blocks
-
- Transaction Control Statements in Autonomous Bloc
ks
- Introduction to Schema Objects
- Overview of Tables
-
- How Table Data Is Stored
-
- Row Format and Size
- Rowids of Row Pieces
- Column Order
- Table Compression
-
- Using Table Compression
- Nulls Indicat
e Absence of Value
- Default Values for Columns
-
- Default Value Insertion and Integrity Constraint Checking
- Partitione
d Tables
- Nested Tables
- Temporary Tables
-
- Segment Allocation
- Parent and Child Tran
sactions
- External Tables
-
-
The Access Driver
- Data Loading with External Tables
- Parallel Access to External Tables
- Overview of Views
-
- How Views are Stored
- How Views Are Used<
/dd>
- Mechanics of Views
-
- Globalization Suppor
t Parameters in Views
- Use of Indexes Against Views
- Dependencies and Views
- Updatable Join Views
- Object Views
- Inline Views
- Overview of Materialized Views
-
- Define Constraints on Views
- <
a href="schema.htm#sthref849">Refresh Materialized Views
- Materialized View Logs
<
/dl>
- Overview of Dimensions
- Overview of the Seque
nce Generator
- Overview of Synonyms
- Overview o
f Indexes
-
- Unique and Nonunique Indexes
- Composite Indexes
- Indexes and Keys
- Indexe
s and Nulls
- Function-Based Indexes
-
-
Uses of Function-Based Indexes
- Optimization with Function-Based Indexes
- Dependencies of Function-Based Indexes
- How Indexes A
re Stored
-
- Format of Index Blocks
- Th
e Internal Structure of Indexes
- Index Properties
- Advantages of B-tree Structure
- Index Unique Scan
- Index Range Scan
- Key Compression
-
- Prefix and Suffix Entries
- Performance and Storage Considerations
- Uses of Key Compression
- Reverse Key Indexes
- Bitmap Indexes
-
- Benefits for Data
Warehousing Applications
- Cardinality
- Bitmap
Index Example
- Bitmap Indexes and Nulls
- Bit
map Indexes on Partitioned Tables
- Bitmap Join Indexes
- <
a href="schema.htm#sthref1034">Overview of Index-Organized Tables
-
- Benefits of
Index-Organized Tables
- Index-Organized Tables with Row Overflow Area
- Secondary Indexes on Index-Organized Tables
- Bitmap Indexes on
Index-Organized Tables
-
- Mapping Table
- Partitioned Index-Organized Tables
- B-tree Indexes on UROWID Columns for He
ap- and Index-Organized Tables
- Index-Organized Table Applications
- Overview of Application Domain Indexes
- Overview of Clus
ters
- Overview of Hash Clusters
- Introduction to Dependency Issues
- Resolution of Schema Object Dependen
cies
-
- Compilation of Views and PL/SQL Program Units
-
- Views and Base Tables
- Program Units and Referenced Objects
- Data Warehousing Considerations
- Session Stat
e and Referenced Packages
- Security Authorizations
- Object Name Resolution
- Shared SQL Dependency Management
- Local and Remote Dependency Management
-
- Management of Local Dependencies
- Management of Remote Dependencies
-
<
dd>Dependencies Among Local and Remote Database Procedures
- Dependencies Among Other Remote Schema Objects
- Dependencies of Applications
<
/dl>
- Introduction to the Data Dictionary
-
Structure of the Data Dictionary
-
- Base Ta
bles
- User-Accessible Views
- SY
S, Owner of the Data Dictionary
How the Data Dictionary Is Used
- How Oracle Uses the Data Dictionary
-
- Public Synonyms for Data Dictionary Views
- Cache the Data Dictionary for Fast Acce
ss
- Other Programs and the Data Dictionary
- How to Use the Data Dictionary
-
- Views with the Prefix USER
- Views with the Prefix ALL
- Views with the Pre
fix DBA
- The DUAL Table
Dynamic Performance Tables
Database Object Metadata
-
Introduction to Oracle Memory Structures
- Overview of the
System Global Area
-
- The SGA_MAX_SIZE Initialization Parameter
- Automatic Shared Memory Management
-
- The SGA_TARGET
Initialization Parameter
- Automatically Managed SGA Components
- Manually Managed SGA Components
- Persistence of Automatically Tuned V
alues
- Adding Granules and Tracking Component Size
- Database Buffer Cache
-
- Organization of the Database Buffer Cac
he
- The LRU Algorithm and Full Table Scans
- S
ize of the Database Buffer Cache
- Multiple Buffer Pools
- Redo Log Buffer
- Shared Pool
-
- Library Cache
- Shared SQL Areas and Private SQL Areas
- PL/SQL Program Units and the Shared Pool
- Dictionary Cache
- Allocation and Reuse of Memory in the Shared Pool
- Large Pool
- Java Pool
- Streams
Pool
- Control of the SGA's Use of Memory
- Oth
er SGA Initialization Parameters
-
- Physical Memory
- SGA Starting Address
- Extended Buffer Cache Mechanism
<
/dl>
- Overview of the Program Global Areas
-
- Content of the PGA
-
- Private SQL Area
- Session Memory
- SQL Work Areas
- PGA Memory Management for Dedicated Mode
- Dedicated and Shared Servers
- Software Code Areas
- In
troduction to Processes
-
- Multiple-Process Oracle Systems
- Types of Processes
- Overview of User Processes
-
- Connections and Sessions
- Ov
erview of Oracle Processes
-
- Server Processes
- Background Processes
-
- Database Writer Process (DBWn)
- Log Writer Process (LGWR)
- C
heckpoint Process (CKPT)
- System Monitor Process (SMON)
- Process Monitor Process (PMON)
- Recoverer Process (RECO)
- Job Queue Processes
- Archiver Processes (ARCn)
- Queue Monitor Processes (QMNn)
- Other Background Processes
- Trace Files and the
Alert Log
- Shared Server Architecture
-
- Dispatcher Request and Response Queues
-
- Dispatcher Processes (
Dnnn)
- Shared Server Processes (Snnn)
- Restricted Operations of the Shared Server
- Dedicated Server Configuration
- The Program Interface
-
- Program Interface Structure
- Program Interface Drivers<
/dd>
- Communications Software for the Operating System
- Introduction to Client/Server Architecture
- Over
view of Multitier Architecture
-
- Clients
- Application Servers
- Database Servers
- Overview of Oracle Net Services
-
- How Oracle Net Services Wo
rks
- The Listener
-
- Service Info
rmation Registration
- Introduction to Oracle Uti
lities
- Overview of Data Pump Export and Import
-
- Data Pump Export
- Data Pump Import
- Overview of the Data Pump API
- Overview of the Metadata API
- Overview of SQL*Loader
- Overview of External Tables
- Overview of LogMiner
- Overview of DBVERIF
Y Utility
- Overview of DBNEWID Utility
- Introduction to an Oracle Instance
-
- The Instance and the Database
- Connection with Administrator Privileges
- Initialization Parameter Files and Server Parameter Files
-
- How Parameter Values Are Changed
- Overview of Instance a
nd Database Startup
-
- How an Instance Is Started
-
- Restricted Mode of Instance Startup
- Forced Startup in Abnorma
l Situations
- How a Database Is Mounted
-
- How a Database Is Mounted with Real Application Clusters
- How a Standb
y Database Is Mounted
- How a Clone Database Is Mounted
- What Happens When You Open a Database
-
- Instance Recover
y
- Undo Space Acquisition and Management
- R
esolution of In-Doubt Distributed Transaction
- Open a Database in Read-Only Mode
- Overview of Database and Instance Shutdown
-
- Close a Database
-
- Close the Database by Terminating t
he Instance
- Unmount a Database
-
Shut Down an Instance
-
- Abnormal Instance Shutdown
- Introduction to Data Concurrency and Consistency in a Multiuser Envi
ronment
-
- Preventable Phenomena and Transaction Isolation Levels
- <
a href="consist.htm#sthref1930">Overview of Locking Mechanisms
- How Oracle Man
ages Data Concurrency and Consistency
-
- Multiversion Concurrency Control
- Statement-Level Read Consistency
- Transaction-Le
vel Read Consistency
- Read Consistency with Real Application Clusters
- Oracle Isolation Levels
-
- Set the Isolation Level
- Read Committed Isolation
- Serializable Isol
ation
- Comparison of Read Committed and Serializable Isolation
-
<
dl>
- Transaction Set Consistency
- Row-Level Locking<
/a>
- Referential Integrity
- Distributed Transac
tions
- Choice of Isolation Level
-
- Read Committed Isolation
- Serializable Isolation
- Quiesce Database
How Oracle Locks Data
<
dd>
- Transactions and Data Concurrency
-
- Modes of Locking
- Lock Duration
- Data Lo
ck Conversion Versus Lock Escalation
- Deadlocks
-
- Deadlock Detection
- Avoid Deadlocks
- Types of Locks
- DML Locks
-
- Row Locks (TX)
- Table Locks (TM)
- DML Locks Automatically Acquired for DML Statements
- DDL Locks<
/a>
-
- Exclusive DDL Locks
- Share DDL L
ocks
- Breakable Parse Locks
- Duration of DD
L Locks
- DDL Locks and Clusters
-
Latches and Internal Locks
-
- Latches
- Internal Locks
- Explicit (Manual) Data Locking
- Oracle Lock Management Services
Overview of Oracle Flashba
ck Query
- Flashback Query Benefits
- Some Uses of Flashback Query
- Installing Oracle and Getting St
arted
-
- Simplified Database Creation
- Instant Client
- Automated Upgrades
- Bas
ic Initialization Parameters
- Data Loading, Transfer, and Archiving
<
dd>Intelligent Infrastructure
-
- Automatic Work
load Repository
- Automatic Maintenance Tasks
- Server-Generated Alerts
- Advisor Framework
- Performance Diagnostic and Troubleshooting
- Application and SQL Tuning
- Memory Management
- Space Management
-
- Automatic Undo Management
- Oracle-Managed
Files
- Free Space Management
- Proactive Sp
ace Management
- Intelligent Capacity Planning
- Transparent Space Reclamation
- Storage Management
- Backup and Recovery
-
- Recovery Manager
- Mean Time to Recovery
- Self Service Error Correction
- Configuration Management
- Workload Mana
gement
-
- Overview of the Database Resource Manager
-
- Database Resource Manager Concepts
- Overview of Se
rvices
-
- Workload Management with Services
- High Availability with Services
- Automatic Storage Managem
ent
-
- Basic Automatic Storage Management Concepts
-
- Disk Groups
- Automatic Storage Management Files
-
Automatic Storage Management Templates
- Automatic Stora
ge Management Disks
- Failure Groups
- Automa
tic Storage Management Instances
- Benefits of Using Automatic Storage Manageme
nt
- Job Scheduler
-
- What
Can the Scheduler Do?
-
- Schedule Job Execution Based on Time
- Reuse Scheduler Objects
- Schedule Job Processing that Model
s Business Requirements
- Manage and Monitor Jobs
- Execute and Manage Jobs in a Clustered Environment
- Transfer Files
<
/dd>
- Basic Scheduler Concepts
-
- Programs
- Schedules
- Jobs
- Advanced Scheduler Concepts
-
- Job Classes
- Windows
-
Introduction to Backup
-
- Consistent and Inconsistent Backups
-
- Overview of Consistent Backups
- Overview of Incons
istent Backups
- Whole Database and Partial Database Backups
-
- Whole Database Backups
- Tablespace Backups
- Datafile Backups
- RMAN and User-Managed
Backups
-
- RMAN with Online Backups
- Control File Backups
- Archived Redo Log Backups
- Introduction to Recovery
-
- Overview of Media Recov
ery
-
- Complete Recovery
- Incomplet
e Recovery
- Datafile Media Recovery
- Block
Media Recovery
- Overview of RMAN and User-Managed Restore and Recovery
-
- RMAN Restore and Recovery
- User-Managed
Restore and Recovery
- Recovery Using Oracle Flashback Technology
-
- Overview of Oracle Flashback Database
- Overv
iew of Oracle Flashback Table
- Other Types of Oracle Recovery
-
- Overview of Redo Application
- Overview of Instan
ce and Crash Recovery
Deciding Which Recovery Technique to Use<
/dd>
- When to Use Media Recovery
- When to
Use Oracle Flashback
- When to Use CREATE TABLE AS SELECT Recovery
- When to Use Import/Export Utilities Recovery
- When to Use Tables
pace Point-in-Time Recovery
Flash Recovery Area
- Flash Recovery Area Disk Limit
- Introduction to Data Warehousing and Business Intelligence
-
- Characteristi
cs of Data Warehousing
-
- Subject Oriented
- Integrated
- Nonvolatile
- Time
Variant
- Differences Between Data Warehouse and OLTP Systems
-
- Workload
- Data Modifications
- Schema Design
- Typical Operations
- Historical Data
- Data Warehouse Architecture
-
- Data Warehouse Architecture (Basic)
- D
ata Warehouse Architecture (with a Staging Area)
- Data Warehouse Architecture (with a S
taging Area and Data Marts)
Overview of Extraction, Transformation
, and Loading (ETL)
- Transportable Tablespaces
- Table Functions
- External Tables
- Table Compression
- Change Data Capture
Overview of Materialized Views for Data Warehouses
Overview of Bitm
ap Indexes in Data Warehousing
Overview of Parallel Execution
- <
a href="bus_intl.htm#sthref2491">How Parallel Execution Works
Overview of An
alytic SQL
- SQL for Aggregation
- SQL for Analysis
- SQL for Modeling
Overview of OLAP Capabilities
- Benefits of OLAP and RDBMS Integration<
/a>
-
- Scalability
- Availability<
/dd>
- Manageability
- Backup and Recovery
- Security
Overview of Data Mi
ning
- Introduction to High Availability
- Overview of Unplanned Downtime
-
- Oracle Solutions to System Fail
ures
-
- Overview of Fast-Start Fault Recovery
- Overview of Real Application Clusters
- Oracle Solutions to Data Fa
ilures
-
- Overview of Backup and Recovery Features for High Availability
- Overview of Partitioning
- Overview of Transparent
Application Failover
- Oracle Solutions to Disasters
-
- Overview of Oracle Data Guard
- Oracle Solutions
to Human Errors
-
- Overview of Oracle Flashback Features
- Overview of LogMiner
- Overview of Security Features for High Ava
ilability
- Overview of Planned Downtime
-
- System Maintenance
- Data Maintenance
- Database Maintenance
- Introduction to Partitioning
-
- Partition Key
- Partitioned Tables
- Partitioned Index-Organized Tables
- Overview of Partitioning Methods
-
- R
ange Partitioning
-
- Range Partitioning Example
- List Partitioning
-
- List Partitioning Example
- Hash Partitioning
-
- Hash Pa
rtitioning Example
- Composite Partitioning
-
- Composite Partitioning Range-Hash Example
- Composite Partitionin
g Range-List Example
- When to Partition a Table
- Overview of Partitioned Indexes
-
- Local Partitione
d Indexes
- Global Partitioned Indexes
-
- Global Range Partitioned Indexes
- Global Hash Partitioned Indexes
-
Maintenance of Global Partitioned Indexes
-
Global Nonpartitioned Indexes
- Miscellaneous Information about Creating Indexes on Part
itioned Tables
- Using Partitioned Indexes in OLTP Applications
- Using Partitioned Indexes in Data Warehousing and DSS Applications
- Partitioned Indexes on Composite Partitions
- Partitioning to Improve Perf
ormance
-
- Partition Pruning
-
- Partition Pruning Example
- Partition-wise Joins
- Parallel DML
- Introduction to C
ontent Management
- Overview of XML in Oracle
- Overview of LOBs
- Overview of Oracle Text
-
- Oracle Text Index Types
- Oracle Text Document Services
- Oracle Text Query Package
- Oracle Text Advanced Features
- Overview of Oracle Ultra Search
- Over
view of Oracle interMedia
- Overview of Oracle Spatial
- Introduction to Database Security
-
- Da
tabase Users and Schemas
-
- Security Domain
- Privileges
- Roles
-
Storage Settings and Quotas
-
- Default Tablespace
- Temporary Tablespace
- Tablespace Quotas
- Profiles and Resource Limits
- Overview of Authent
ication Methods
-
- Authentication by the Operating System
- Authentication by the Network
-
- Third Party-Based Au
thentication Technologies
- Public-Key-Infrastructure-Based Authentication
-
Remote Authentication
- Authentication by th
e Oracle Database
-
- Password Encryption While Connecting
- Account Locking
- Password Lifetime and Expiration
Password Complexity Verification
- Multiti
er Authentication and Authorization
- Authentication by the Secure Socket Layer Protocol
- Authentication of Database Administrators
Overview of Authorization
- User Resource Limits and Profiles
-
- Types of System Resources and Limits
- Profiles
- Introduction to Privileges
-
- System Privileges
- Schema Object Privileges
<
dd>Introduction to Roles
- Common Uses for R
oles
- Role Mechanisms
- The Operating Syst
em and Roles
Secure Application Roles
Overview of Access Restrictions on Tables, Views, Synonyms, or Rows
- Fine-Grained Access Control
-
- Dynamic Predicates
- Application Context
-
- Dynamic Contexts<
/a>
- Fine-Grained Auditing
Overview of Security Policies
- System Security Policy
-
<
dd>Database User Management
- User Authentication<
/dd>
- Operating System Security
Data Se
curity Policy
User Security Policy
- General User Security
- End-User Security
- Administrator Security
- Application Developer Security
- Application Administrator Security
Password Management
Policy
Auditing Policy
Overv
iew of Database Auditing
- Types and Records of Auditing
-
Audit Records and the Audit Trails
- Introduction to Data Integrity
-
- Types of Data Integrity
-
- Null Rule
- Unique Column Values<
/a>
- Primary Key Values
- Referential Integrit
y Rules
- Complex Integrity Checking
- How Oracle Enforces Data Integrity
-
- Integrity Constraints Description
- Database Triggers
- Ov
erview of Integrity Constraints
-
- Advantages of Integrity Constraints
-
- Declarative Ease
- Centralized Rules
- Maximum Application Development Productivity
- Immediate User Feedback
- Superior Performance
- Flexibility for Data Loads and Identification of Integrity Violations
- The Performance Cost of Integrity Constraints
- Types of Integrity Constra
ints
-
- NOT NULL Integrity Constraints
- UNIQUE Key Integrity Constraints
-
- Unique Keys
- UNIQUE Key Constraints and Indexes
- Combine UNIQUE Key and NOT N
ULL Integrity Constraints
- PRIMARY KEY Integrity Constraints
-
- Primary Keys
- PRIMARY KEY Constraints and Inde
xes
- Referential Integrity Constraints
-
- Self-Referential Integrity Constraints
- Nulls and Foreign Keys
- Actions Defined by Referential Integrity Constraints
- Concurrency Control, Indexes, and Foreign Keys
- CHECK Integrity Cons
traints
-
- The Check Condition
- M
ultiple CHECK Constraints
The Mechanisms of Constraint Checking
- Default Column Values and Integrity Constraint Checking
Deferred Constraint Checking
- Constraint A
ttributes
- SET CONSTRAINTS Mode
- Unique C
onstraints and Indexes
Constraint States
- Constraint State Modification
- Introduction to
Triggers
-
- How Triggers Are Used
-
- Some Cautionary Notes about Triggers
- Triggers Compared with Declarative I
ntegrity Constraints
- Parts of a Trigger
-
- The Triggering Event or Statement
- Trigger Restriction
- Trigger Action
- Types of Trigge
rs
-
- Row Triggers and Statement Triggers
-
- Row Triggers
- Statement Triggers
- BEFORE and AFTER Triggers
-
- BEFORE Triggers
AFTER Triggers
- Trigger Type Combinations
<
/dl>
- INSTEAD OF Triggers
-
- Modify V
iews
- Views That Are Not Modifiable
- INST
EAD OF Triggers on Nested Tables
- Triggers on System Events and User Events
-
- Event Publication
- Event Attrib
utes
- System Events
- User Events
Trigger Execution
- The Execution Model for Triggers and Integrity Constraint Checking
- Data Access for Tr
iggers
- Storage of PL/SQL Triggers
- Execu
tion of Triggers
- Dependency Maintenance for Triggers
- Introduction to Oracle Information Integration
- Federated Access
-
- Distributed SQL
- Location Transparency
- SQL and COMMIT Transparency
<
dd>Distributed Query Optimization
Informat
ion Sharing
- Oracle Streams
-
- Oracle Streams Architecture
- Replication with Oracle Streams
- Oracle Streams Advanced Queuing
- Change Data Capture
- Heterogeneous Environments
- Oracle Streams Us
e Cases
- Materialized Views
Integrating Non-Oracle Systems
- Generic Connectivity
- Oracle Transparent Gateways
- Overview of SQL
-
- SQL Statements
-
- Data Manipulation Language Statements
- Data Definition Language Statem
ents
- Transaction Control Statements
- Ses
sion Control Statements
- System Control Statements
- Embedded SQL Statements
- Cursors
-
- Scrollable Cursors
- Shared SQL
- Parsing
- SQL Processing
-
- SQL Statement Execution
- DML Statement Processing
- DDL Statement Processing
- Control of Transactions
- Overview of the Optimizer
-
- E
xecution Plans
- Overview of Procedural Languages
-
- Overview of PL/SQL
-
- How PL/SQL Runs
- Language Constructs for PL/SQL
- PL/SQL Pro
gram Units
- Stored Procedures and Functions
- PL/SQL Packages
- PL/SQL Collections and Records
- PL/SQL Server Pages
- Overview of Java
-
- Java and Object-Oriented Programming Terminology
- Class H
ierarchy
- Interfaces
- Polymorphism
- Overview of the Java Virtual Machine (JVM)
- Wh
y Use Java in Oracle?
- Oracle's Java Application Strategy
<
/dl>
- Introduction to Oracle Application Deve
lopment Languages
- Overview of C/C++ Programming Languages
-
- Overview of Oracle Call Interface (OCI)
- Overview
of Oracle C++ Call Interface (OCCI)
-
- OCCI Associative Relational and Obje
ct Interfaces
- OCCI Navigational Interface
- Overview of Oracle Type Translator
- Overview of Pro*C/C++ Precomp
iler
-
- Dynamic Creation and Access of Type Descriptions
<
/dl>
- Overview of Microsoft Programming Languages
-
- Open Database Connectivity
- Overview of Oracle Objects for OLE
-
- OO4O Automation Server
- Oracle Data Control
- The Oracle Objects for OLE C++ Class Library
- Oracle Data Provider for .NET
-
Overview of Legacy Languages
-
- Overview of Pro*Cobol Precompiler
<
dd>Overview of Pro*FORTRAN Precompiler
- Introduction to Oracle Datatypes
- Overview of Character Datatypes<
/dd>
-
- CHAR Datatype
- VARCHAR2 and VARCHA
R Datatypes
-
- VARCHAR Datatype
- Length Semantics for Character Datatypes
- NCHAR and NVARCHAR2 Datatypes
-
- NCHAR
- NVARCHAR2
- Use of Unicode Data in an Oracle Database
-
- Implicit Type Conversion
- LOB Character Datatypes
- LONG Datatype
- Overview of Numeric Datatypes
-
- NUMBER Datatype
-
- Internal N
umeric Format
- Floating-Point Numbers
-
- BINARY_FLOAT Datatype
- BINARY_DOUBLE Datatype
- Overview of DATE Datatype
-
- Use of
Julian Dates
- Date Arithmetic
- Centuries
and the Year 2000
- Daylight Savings Support
- Time Zones
- Overview of LOB Datatypes
-
- BLOB Datatype
- CLOB and NCLOB Datatypes
- BFILE Datatype
- Overview of RAW and LONG RAW Datatypes
- Overview of ROWID and UROWID Datatypes
-
- The ROWID Pseudocolumn
- Physical Rowids
-
- Extended Rowids
- Restricted Rowids
- Examples of Rowid Use
- How Rowids Are Used
- Logical Rowids
-
- Comparison of Logical Rowids wit
h Physical Rowids
- Guesses in Logical Rowids
- Rowids in Non-Oracle Databases
- Overview of ANSI, DB2, and SQL
/DS Datatypes
- Overview of XML Datatypes
-
- XMLType Datatype
- Overview of URI Datatypes
- Overview of Data Conversion
-
Introduction to Object Datatypes
-
- Complex Data Models
- Multimedia Datatypes
- Overview of Object Datatype Catego
ries
-
- Object Types
-
- Typ
es of Methods
- Object Tables
- Object Identi
fiers
- Object Views Description
- REFs
- Collection Types
-
- VARRAYs
- Nested Tables
- Overview
of Type Inheritance
-
- FINAL and NOT FINAL Types
- NOT INSTANTIABLE Types and Methods
- Overview of User-Defined A
ggregate Functions
-
- Why Have User-Defined Aggregate Functions?
- Overview of Datatype Evolution
- Introduction to
Object Views
-
- Advantages of Object Views
- Use of Object Views
- Updates of Object Views
- Updates of Nested Table Columns in Views
- View Hierarchies
