List of Sidebars
What Is a Sidebar?
Chapter 2: Fundamental SQL Concepts and Principles
ANSI/ISO Standard Documents
Introducing Unicode
Character vs. Special Files
Precision and Scale for
NUMERIC and DECIMAL Datatypes
Selecting Correct Data
Types
Understanding TIMESTAMP WITH
LOCAL TIME ZONE Data Type
Chapter 4: Creating RDBMS Objects
Using INITIALLY DEFERRED
Constraints
Index Organized Tables and
Other Physical Properties
Creating Summary
Tables
Clustered Indexes
Simulating OR REPLACE Clause in
MS SQL Server
Chapter 6: Data Manipulation Language (DML)
Archiving Based on Complex Business Rules
RDBMS error messages
Dangers of the WHERE Clause
Chapter 7: Sessions, Transactions, and Locks
Setting SQL*Plus Session
Parameters
Orphaned Sessions
Explicit and Implicit
Transactions
Nested Transactions
Distributed Transactions
Fully Qualified Column Names
Getting Random Numbers in a
Different Range
NULL and Aggregate
Functions
Conversion Pitfalls
Why Operator Precedence Is
Important
Using Boolean Logic for Data
Safety
Chapter 12: SQL and RDBMS Security
Oracle 9i User
PROFILE
SQL Server 2000 DENY
Statement
OS Security Integration
How XOR Encryption Works
What Is C2 Security
Level?
Chapter 13: The System Catalog and INFORMATION_SCHEMA
Getting Help
Chapter 14: Stored Procedures, Triggers, and User-Defined Functions
Sequential and Event-Driven Programming
Passing Parameters by Name and by Value
Chapter 15: Dynamic and Embedded SQL Overview
Embedded and Dynamic SQL
Terminology
Embedded (Static) Versus Dynamic
SQL: Advantages and Disadvantages
JDBC Connector and Java Data Objects
(JDO)
Oracle Gateways
Microsoft DBLIB Legacy
Chapter 17: New Developments—XML, OLAP, and Objects
XML and Web Services
Future of XML
OLAP Rules
ROLAP, MOLAP, and HOLAP...
Collections and Arrays
Appendix L: A Brief Introduction to the Number Systems, Boolean Algebra, and Set Theory
Set Operations on Multielement Operands