Oracle® PL/SQL® Interactive Workbook, Second Edition

SQL Standards

The American National Standards Institute (http://www.ansi.org) first published a standard SQL specification in 1989. The ANSI SQL standard was later revised in 1992, and this is often referred to as SQL-92 or SQL-2. This was revised again, giving rise to the latest standard, known as SQL-99. Sometimes it is called SQL-3. Database vendors and third-party software companies have had varying levels of conformance to this standard. Most major database vendors support the SQL-92 standard. Generally what you find is that most vendors have their own extensions to the SQL language. Oracle is no exception in this matter. Nonetheless, Oracle has made efforts to maintain the ANSI standard. The reason for this is to provide an easier migration ...