This section of the Knowledgebase contains the full text of the book SQL-99 Complete, Really, by Peter Gulutzan & Trudy Pelzer.
-
00 - Preface
Preface If you've ever used a relational database product, chances are that... -
01 - Introduction
SQL-99 (more commonly still called, "SQL3", the term we'll use throughout t... -
02 - General Concepts
A database system can be described as essentially nothing more than a compu... -
03 - Numbers
In SQL, a number — i.e.: any signed, or unsigned, combination of the digits... -
04 - Bit Strings
In SQL, a bit string is either a binary bit string or a hexadecimal bit str... -
05 - Binary Strings
In SQL, a binary string, or BLOB, is any arbitrary sequence of zero or more... -
06 - Characters
"Now we know our Alphabet all the way from A to Z[ed]" (Grade 1 Tune) "Now ... -
07 - Character Strings
In SQL, a character string is any sequence of zero or more alphanumeric cha... -
08 - Temporal Values
In SQL, a temporal value is either a datetime (i.e.: a date, a clock time o... -
09 - Boolean Values
In SQL, a Boolean value — either TRUE, FALSE or UNKNOWN — is a truth value. A Boolean val -
10 - Collection Types
[Obscure Rule] applies for this entire chapter. In SQL, a <collection type>... -
11 - Row Types
[Obscure Rule] applies for this entire chapter. In SQL, a <row type> is a r... -
12 - Reference Types
[Obscure Rule] applies for this entire chapter. In SQL, a <reference type> ... -
13 - NULLs
"The problem isn't what they don't know. It's what they do know that ain't ... -
14 - SQL Clusters
In this chapter, we'll describe SQL Clusters in detail, and show you the sy... -
15 - AuthorizationIDs
In this chapter, we'll describe <AuthorizationID>s in detail, and show you ... -
16 - SQL Catalogs
In this chapter, we'll describe SQL Catalogs in detail, and show you the sy... -
17 - SQL Schemas
The SQL Standard describes the concepts on which SQL is based in terms of O... -
18 - SQL Tables and Views
In this chapter, we'll describe SQL Tables in detail, and show you the synt... -
19 - SQL Domains
In this chapter, we'll describe SQL Domains in detail, and show you the syn... -
20 - SQL Constraints and Assertions
In this chapter, we'll describe SQL Constraints and SQL Assertions in detai... -
21 - SQL Character Sets
[Obscure Rule] applies to this entire chapter. In this chapter, we'll descr... -
22 - SQL Collations
[Obscure Rule] applies to this entire chapter. In this chapter, we'll descr... -
23 - SQL Translations
[Obscure Rule] applies to this entire chapter. In this chapter, we'll descr... -
24 - SQL Triggers
"If you press the SECOND dorsal fin-spine on a trigger fish, an amazing eve... -
25 - SQL-Invoked Routines
In this chapter, we'll describe SQL-invoked routines in detail, and show yo... -
26 - PSM: Not Just Persistent Stored Modules
The initials "PSM" refer to the specifications of a document labelled "ISO/... -
27 - User-Defined Types
[Obscure Rule] applies for this entire chapter. -
28 - Introduction to SQL-Data Operations
In this chapter, we'll describe some common SQL constructs. We'll be using ... -
29 - Simple Search Conditions
We've come at last to the point where we can begin showing you the most imp... -
30 - Searching with Joins
It's France in the 1600s. Rene Descartes is playing cards with Madame du Ba... -
31 - Searching with Subqueries
A subquery is a parenthesized query enclosed within some outer SQL statemen... -
32 - Searching with Set Operators
-
33 - Searching with Groups
This chapter deals with three optional points of a SELECT statement: the GR... -
34 - Sorting Search Results
In SQL, you can only sort search results returned by a Cursor. However, whe... -
35 - Changing SQL-data
The SQL-data change statements are INSERT, UPDATE and DELETE. Many people c... -
36 - SQL Transactions
"An SQL-transaction (transaction) is a sequence of executions of SQL-statem... -
37 - SQL Transaction Concurrency
-
38 - SQL Sessions
An SQL-session spans the execution of one or more consecutive SQL statements by a single user. -
39 - Embedded SQL Binding Style
SQL DBMSs communicate with SQL applications through a common programming la... -
40 - SQL/CLI Binding Style
-
41 - SQL/CLI: env Functions
In this chapter, we'll describe the first essential CLI resource: the env. ... -
42 - SQL/CLI: dbc Functions
In this chapter, we'll describe the second essential CLI resource: the dbc. -
43 - SQL/CLI: stmt Functions
In this chapter, we'll describe the third essential CLI resource: the stmt. -
44 - SQL/CLI Statement Functions
Of the 62 CLI functions, only three actually handle what we know as "SQL st... -
45 - SQL/CLI: Cursor Functions
When you execute a query, you are implicitly opening a Cursor. -
46 - SQL/CLI: desc Functions
In this chapter, we'll describe the fourth essential CLI resource: the desc... -
47 - SQL/CLI: Diagnostic Functions
What if something goes wrong? -
48 - SQL/CLI: General Functions
In this chapter, we discuss SQLDataSources, SQLGetFunctions, and SQLGetInfo... -
49 - SQL/CLI: Deferred Parameter Functions
This short chapter describes an option for passing input parameters after e... -
50 - SQL/CLI: Locator Functions
In this chapter, we'll describe the CLI locator functions: SQLGetLength, SQ... -
51 - SQL/CLI: Catalog Functions
The CLI Catalog functions are so called because they involve implicit searc... -
52 - Module Binding Style
SQL DBMSs communicate with SQL applications through a common programming la... -
53 - Style