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 the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.