Preface

This preface introduces the Oracle Database Lite SQL Reference. This reference describes the Structured Query Language (SQL) used to manage information in an Oracle Database 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).

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 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 does not own or control. Oracle neither evaluates nor makes any representations regarding the accessibility of these Web sites.

Structure

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 Database Lite Keywords and Reserved Words"

  Contains a list and description of Oracle Lite keywords and reserved words.

• Appendix B, "SQL Limitations For Oracle Database Lite"

  Contains the SQL limitations for the Oracle Lite database.

• Appendix C, "Oracle Database Lite Datatypes"

  Contains a list and description of Oracle Lite datatypes.

• Appendix D, "Oracle Database Lite Literals"

  Contains a list and description of Oracle Lite literals.

• Appendix E, "Index Creation Options"

  Describes additional options for the CREATE INDEX command.

• Appendix F, "Syntax Diagram Conventions"

  Explains the syntax diagrams and document conventions used in the Oracle Database Lite SQL Reference.