Oracle7 Server SQL Reference
SQL Standards
Oracle7 SQL complies with industry accepted standards. Oracle Corporation ensures future compliance with evolving SQL standards by actively involving key personnel in SQL standards committees. Industry accepted committees are the American National Standards Institute (ANSI) and the International Standards Organization (ISO), which is affiliated with the International Electrotechnical Commission (IEC), both of which have accepted SQL as the standard language for relational databases. When a new SQL standard is simultaneously published by these organizations, the names of the standards conform to conventions used by the organization, but the technical details are exactly the same.
The latest SQL standard published by ANSI and ISO is often called SQL-92 (and sometimes SQL2). The formal names of the new standard are:
- ANSI X3.135-1992, "Database Language SQL"
- ISO/IEC 9075:1992, "Database Language SQL"
SQL-92 defines three levels of compliance, Entry, Intermediate, and Full. Oracle7, Release 7.2 conforms to Entry level compliance, and has many features that conform to Intermediate or Full level compliance.
Release 7.2 conformance to Entry Level SQL-92 was tested by the National Institute for Standards and Technology (NIST) using the Federal Information Processing Standard (FIPS), FIPS PUB 127-2.