Menu

Oracle Reference

This page collects reference material for Oracle Database, including SQL functions and related database topics.

To reformat an Oracle query in your browser, use the SQL formatter. Oracle PL/SQL is selected for you; the query stays in your browser and formatting does not execute or validate it.

For a cross-database task guide that includes Oracle USER_TABLES, see how to list tables in SQL databases.

For a comparison of regular and materialized view listing commands across engines, see List Views in SQL.

For the difference between Oracle schemas and database names in MySQL, PostgreSQL, SQL Server, and SQLite, see List Databases in SQL.

  1. Oracle Character Functions

    This page organizes commonly used Oracle string/character functions, allowing you to efficiently manipulate strings/characters.

  2. Oracle Character Set Functions

    Character set functions return information about character sets. This page summarizes the character set functions in Oracle.

  3. Oracle Collation Functions

    The collation functions return information about collation settings. This page summarizes collation functions in Oracle.

  4. Oracle Conversion Functions

    Conversion functions convert a value of one data type to another data type. This page summarizes conversion functions available in Oracle.

  5. Oracle Data Types.

    Oracle supports various data types, and this page provides a compilation of commonly used data types in Oracle.

  6. Oracle Datetime Functions

    This page summarizes common date and time functions in Oracle.

  7. Oracle Encoding And Decoding Functions

    Explore Oracle DECODE, DUMP, VSIZE, ORA_HASH, and STANDARD_HASH functions for decoding, inspecting, and hashing expressions.

  8. Oracle Environment and Identifier Functions

    Environment and identifier functions provide information about the instance and session. This page summarizes the Oracle environment and identifier functions.

  9. Oracle General Comparison Functions

    General comparison functions determine the maximum and/or minimum values in a set of values. This page summarizes the general comparison functions available in Oracle.

  10. Oracle JSON Functions

    JSON functions allow you to query and generate JSON data. This page summarizes the JSON functions available in Oracle.

  11. Oracle null-related Functions

    NULL-related functions help to deal with NULL values. This page organizes the commonly used NULL-related functions in Oracle.

  12. Oracle Numeric Functions

    Numeric functions accept numeric input and return a numeric value. This page organizes commonly used Oracle numeric functions to help you with mathematical operations.