SQL - ANSI (American National Standards Institute) SQL Standard / Reference

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 was revised in 1992 and this is often referred to as:

  • SQL-92
  • or SQL-2.

The latest ISO SQL standard is currently ISO/IEC 9075:1992.

SQL-99 or SQL:1999 is the current standard. SQL-99 is sometimes called SQL-3. The latest standard is SQL:2003 or SQL:200n. This standard is currently under development.

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

Documentation / Reference

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