Database Compatibility for Oracle® Developers Reference Guide

• Introduction
• The SQL Language
  • SQL Syntax
    • Lexical Structure
    • Identifiers and Key Words
    • Constants
      • String Constants
      • Numeric Constants
      • Constants of Other Types
    • Comments
  • Data Types
    • Numeric Types
      • Integer Types
      • Arbitrary Precision Numbers
      • Floating-Point Types
    • Character Types
    • Binary Data
    • Date/Time Types
      • INTERVAL Types
      • Date/Time Input
        • Dates
        • Times
        • Time Stamps
      • Date/Time Output
      • Internals
    • Boolean Types
    • XML Type
  • Functions and Operators
    • Logical Operators
    • Comparison Operators
    • Mathematical Functions and Operators
    • String Functions and Operators
      • Truncation of String Text Resulting from Concatenation with NULL
      • SYS_GUID
    • Pattern Matching String Functions
      • REGEXP_COUNT
      • REGEXP_INSTR
      • REGEXP_SUBSTR
    • Pattern Matching Using the LIKE Operator
    • Data Type Formatting Functions
      • TO_CHAR, TO_DATE, TO_TIMESTAMP, and TO_TIMESTAMP_TZ
        • Date and Time Modifiers
      • IMMUTABLE TO_CHAR(TIMESTAMP, format) Function
      • TO_NUMBER
        • Numeric Modifiers
    • Date/Time Functions and Operators
      • ADD_MONTHS
      • CURRENT DATE/TIME
      • EXTRACT
      • MONTHS_BETWEEN
      • NEXT_DAY
      • NEW_TIME
      • NUMTODSINTERVAL
      • NUMTOYMINTERVAL
      • ROUND
      • SYSDATE
      • TRUNC
    • Sequence Manipulation Functions
    • Conditional Expressions
      • CASE
      • COALESCE
      • NULLIF
      • NVL
      • NVL2
      • GREATEST and LEAST
    • Aggregate Functions
      • LISTAGG
      • MEDIAN
      • STATS_MODE
    • Subquery Expressions
      • EXISTS
      • IN
      • NOT IN
      • ANY/SOME
      • ALL
• System Catalog Tables
  • dual
  • edb_dir
  • edb_password_history
  • edb_policy
  • edb_profile
  • edb_variable
  • pg_synonym
  • product_component_version
• Conclusion