List of Sidebars
List of Sidebars
Preface
- What Is a Sidebar?
Chapter 2: Fundamental SQL Concepts and Principles
- ANSI/ISO Standard Documents
Chapter 3: SQL Data Types
- 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
Chapter 9: Multitable Queries
- Fully Qualified Column Names
Chapter 10: SQL Functions
- Getting Random Numbers in a Different Range
- NULL and Aggregate Functions
- Conversion Pitfalls
Chapter 11: SQL Operators
- 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
Chapter 16: SQL API
- 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
