Entry

Is there a manual for SQL available?

Oct 26th, 2002 04:30
Zi Da, Bernard Niset, Matt Gregory, Nathan Wallace, http://cesspool.crseo.ucsb.edu:8679/TUT1/hist_01.htm

Yes and No
Since SQL was invented by IBM it has been adopted by every major 
database platform.  Because SQL and Embedded SQL are ISO standards, 
they are used for the base SQL dialect in every major flavor of SQL on 
the present-day market.  If you wish to read about SQL or Embedded SQL 
without leaning towards any particular database platform then simply 
download the ISO standards on each.  (SQL and Embedded SQL are 
separate 
standards.)  The ISO is working on SQL3 right now and it is rumored to 
contain a lot of the functionality of Oracle's SQL *Plus.
There are three major flavors to SQL today.
  1.) Transact SQL (MSSQL, Sybase SQL)
  2.) PL/SQL (Oracle)
  3.) SQL * Plus (Oracle)
There are many books on all three.  O'REILLY has the best in my 
opinion 
(Don't they always?).
You can find information on SQL syntax and implementation on the 
vendor 
web sites:
mysql : www.mysql.org
oracle : technet.oracle.com (needs to register for free)
         once registered go to 
http://technet.oracle.com/docs/products/oracle8/doc_index.htm
Microsoft SQL Server: msdn.microsoft.com 
(http://msdn.microsoft.com/library/default.asp?
URL=/library/psdk/sql/8_gs_00.htm) a