Oracle

Oracle Database Data Types

As with all SQLAlchemy dialects, all UPPERCASE types that are known to be valid with Oracle Database are importable from the top level dialect, whether they originate from sqlalchemy.types or from the local dialect:

from sqlalchemy.dialects.oracle import (
    BFILE,
    BLOB,
    BOOLEAN,
    CHAR,
    CLOB,
    DATE,
    DOUBLE_PRECISION,
    FLOAT,
    INTERVAL,
    LONG,
    NCLOB,
    NCHAR,
    NUMBER,
    NVARCHAR,
    NVARCHAR2,
    RAW,
    TIMESTAMP,
    VARCHAR,
    VARCHAR2,
    VECTOR,
)

Types which are specific to Oracle Database, or have Oracle-specific construction arguments, are as follows:

python-oracledb

Changed in version 2.1: oracledb is now the default Oracle dialect when no specific dialect is specified in the URL (e.g. oracle://...).

cx_Oracle

Changed in version 2.1: cx_oracle is no longer the default Oracle dialect. To explicitly use cx_oracle, specify oracle+cx_oracle://... in the URL.