SQL - ANSI (American National Standards Institute) SQL Standard / Reference - SQL (92|99|2003)

About

SQL permits application designers to manipulate sets of rows with a non-procedural (or :"declarative") language, rather than writing iterative loops in conventional languages that process records one at a time.

You specify the result you want, not how to derive it with set processing operations like joins and subqueries to achieve the result you want.

In 1981, The SQL database language was first introduced commercially by Oracle.

The scope of SQL is the definition of data structure and the operations on data stored in that structure.

In 1989, the American National Standards Institute (http://www.ansi.org) published a SQL specification.

The ANSI SQL standard revision:

Year Year Reference Ordering reference Iso (Specification)
1989
1992 SQL-92 SQL-2 ISO/IEC 9075:1992
1999 SQL-99 SQL-3
2003 SQL:2003 ISO/IEC 9075-2:2003

Most major database vendors support the SQL-92 standard. However, the levels of conformance vary. Some vendors have gone beyond the SQL-92 standard and most have their own extensions to the SQL language.

One of the reproach that you can find concerning the ANSI SQL syntax is that it separates join predicates from filter predicates.

Articles Related

Grammar

Bnf Grammar:

Documentation / Reference

  • Bookmark "SQL - ANSI (American National Standards Institute) SQL Standard / Reference - SQL (92|99|2003)" at del.icio.us
  • Bookmark "SQL - ANSI (American National Standards Institute) SQL Standard / Reference - SQL (92|99|2003)" at Digg
  • Bookmark "SQL - ANSI (American National Standards Institute) SQL Standard / Reference - SQL (92|99|2003)" at Ask
  • Bookmark "SQL - ANSI (American National Standards Institute) SQL Standard / Reference - SQL (92|99|2003)" at Google
  • Bookmark "SQL - ANSI (American National Standards Institute) SQL Standard / Reference - SQL (92|99|2003)" at StumbleUpon
  • Bookmark "SQL - ANSI (American National Standards Institute) SQL Standard / Reference - SQL (92|99|2003)" at Technorati
  • Bookmark "SQL - ANSI (American National Standards Institute) SQL Standard / Reference - SQL (92|99|2003)" at Live Bookmarks
  • Bookmark "SQL - ANSI (American National Standards Institute) SQL Standard / Reference - SQL (92|99|2003)" at Yahoo! Myweb
  • Bookmark "SQL - ANSI (American National Standards Institute) SQL Standard / Reference - SQL (92|99|2003)" at Facebook
  • Bookmark "SQL - ANSI (American National Standards Institute) SQL Standard / Reference - SQL (92|99|2003)" at Yahoo! Bookmarks
  • Bookmark "SQL - ANSI (American National Standards Institute) SQL Standard / Reference - SQL (92|99|2003)" at Twitter
  • Bookmark "SQL - ANSI (American National Standards Institute) SQL Standard / Reference - SQL (92|99|2003)" at myAOL
 
language/sql/ansi.txt · Last modified: 2015/06/23 10:40 by gerardnico