Preface

This preface introduces the Oracle9i Lite SQL Reference. This reference describes the Structured Query Language (SQL) used to manage information in an Oracle Lite database.

Oracle SQL is a superset of the SQL-92 standard defined by the American National Standards Institute (ANSI) and the International Standards Organization (ISO).

The following topics are discussed:

Chapter 1, " Using SQL"	Lists and defines important differences between Oracle Lite SQL and Oracle SQL, and explains how to use SQL.
Chapter 2, " SQL Operators"	Describes the following types of Oracle Lite SQL operators: arithmetic, character, comparison, logical, set, and other.
Chapter 3, " SQL Functions"	Describes the following types of Oracle Lite SQL functions: number, character, character returning number values, date, conversion, group, other.
Chapter 4, " SQL Commands"	Describes the following types of Oracle Lite SQL commands: Data Definition Language (DDL), Data Manipulation Language (DML), transaction control, clauses, and pseudocolumns.
Appendix A, " Oracle Lite Keywords and Reserved Words"	Contains a list and description of Oracle Lite keywords and reserved words.
Appendix B, " Oracle Lite Datatypes"	Contains a list and description of Oracle Lite datatypes.
Appendix C, " Oracle Lite Literals"	Contains a list and description of Oracle Lite literals.
Appendix D, " Index Creation Options"	Describes additional options for the CREATE INDEX command.
Appendix E, " Syntax Diagram Conventions"	Explains the syntax diagrams and document conventions used in the Oracle9i Lite SQL Reference.

Documentation Accessibility

Our goal is to make Oracle products, services, and supporting documentation accessible, with good usability, to the disabled community. To that end, our documentation includes features that make information available to users of assistive technology. This documentation is available in HTML format, and contains markup to facilitate access by the disabled community. Standards will continue to evolve over time, and Oracle Corporation is actively engaged with other market-leading technology vendors to address technical obstacles so that our documentation can be accessible to all of our customers. For additional information, visit the Oracle Accessibility Program Web site at:

http://www.oracle.com/accessibility/.

Accessibility of Code Examples in Documentation

JAWS, a Windows screen reader, may not always correctly read the code examples in this document. The conventions for writing code require that closing braces should appear on an otherwise empty line; however, JAWS may not always read a line of text that consists solely of a bracket or brace.

Accessibility of Links to External Web Sites in Documentation

This documentation may contain links to Web sites of other companies or organizations that Oracle Corporation does not own or control. Oracle Corporation neither evaluates nor makes any representations regarding the accessibility of these Web sites.