Chapter 24. Extensions to Standard SQL

This hour covers extensions to ANSI-standard SQL. Although most implementations conform to the standard, many vendors have provided extensions to standard SQL through various enhancements.

The highlights of this hour include:

  • Various implementations

  • Differences between implementations

  • Compliance with ANSI SQL

  • Interactive SQL statements

  • Using variables

  • Using parameters

Various Implementations

Numerous SQL implementations are released by various vendors. All the relational database vendors could not possibly be mentioned; a few of the leading implementations, however, are discussed. The implementations discussed here are Sybase, dBase, Microsoft SQL Server, and Oracle. Other popular vendors providing database products ...

Get Sams Teach Yourself SQL now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.