Entry-Level SQL92 standard

[jrman]

Hello,
I would like to know what are "the Entry-Level SQL92 standard". The list of features that contains this standard.
Thx
JR

[MAK]

www.sqlcourse.com

[skhanal]

You can buy it from ANSI

http://webstore.ansi.org/ansidocstor...92+%28R1998%29

[jrman]

Buy it, I wouldn't have to do that !
Today, the only standard respected by almost all vendors is the "entry level sql 2", written in 1992.
Write code that respects these features should ensure to get a portable code.
But what are these features ?
Perhaps that I could find it in this book to buy, but it is surprising that nobody has already use them ...
Thx,
JR

[skhanal]

All major database vendors say that they comply with SQL-92.

I have not seen a complete list of things that make up SQL-92 in any book or white paper.

I think it may not be a simple list, it could be a volume of documents published by ANSI.

[jrman]

Vendors declare "entry level compliance", as there are three levels in the SQL 2 standard, perhaps that the entry basic level is not so big.
I should ask directly to Oracle ...
They did a flag (FIPS) that determines which statement is compliant or not, they certainly have a list ...
Thx for your comments.
JR

[MAK]

http://www.itl.nist.gov/fipspubs/fip127-2.htm

[jrman]

Hi,
Very good link.
For more I found explicit references to "entry level standard" in RDMS (Unisys database) documentation (take care it's a 3Mo pdf file):
http://public.support.unisys.com/220...308160-017.pdf
Thx for your help,
JR

[bruno.vernay]

There are many informations, and tools, and even the Mimer-SQL database to help you on the subject : Mimer SQL
Good luck !
Bruno