Oracle® Database Lite SQL Reference
Part No. B15917-01
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).
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
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.
The following topics are discussed:
Lists and defines important differences between Oracle Lite SQL and Oracle SQL, and explains how to use SQL.
Describes the following types of Oracle Lite SQL operators: arithmetic, character, comparison, logical, set, and other.
Describes the following types of Oracle Lite SQL functions: number, character, character returning number values, date, conversion, group, other.
Describes the following types of Oracle Lite SQL commands: Data Definition Language (DDL), Data Manipulation Language (DML), transaction control, clauses, and pseudocolumns.
Contains a list and description of Oracle Lite keywords and reserved words.
Contains the SQL limitations for the Oracle Lite database.
Contains a list and description of Oracle Lite datatypes.
Contains a list and description of Oracle Lite literals.
Describes additional options for the CREATE INDEX command.
Explains the syntax diagrams and document conventions used in the Oracle Database Lite SQL Reference.