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 ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access