Enum OracleType

#[non_exhaustive]
pub enum OracleType {
    Varchar2(u32),
    NVarchar2(u32),
    Char(u32),
    NChar(u32),
    Rowid,
    Raw(u32),
    BinaryFloat,
    BinaryDouble,
    Number(u8, i8),
    Float(u8),
    Date,
    Timestamp(u8),
    TimestampTZ(u8),
    TimestampLTZ(u8),
    IntervalDS(u8, u8),
    IntervalYM(u8),
    CLOB,
    NCLOB,
    BLOB,
    BFILE,
    RefCursor,
    Boolean,
    Object(ObjectType),
    Long,
    LongRaw,
    Json,
    Xml,
    Vector(u32, VecFmt),
    Int64,
    UInt64,
}

Oracle data type

Variants (Non-exhaustive)

Non-exhaustive enums could have additional variants added in future. Therefore, when matching against variants of non-exhaustive enums, an extra wildcard arm must be added to account for any future variants.

Varchar2(u32)

VARCHAR2(size)

NVarchar2(u32)

NVARCHAR2(size)

Char(u32)

CHAR(size)

NChar(u32)

NCHAR(size)

Rowid

ROWID

Raw(u32)

RAW(size)

BinaryFloat

BINARY_FLOAT

IEEE 754 single-precision (32-bit) floating-point number

BinaryDouble

BINARY_DOUBLE

IEEE 754 double-precision (64-bit) floating-point number

Number(u8, i8)

NUMBER(precision, scale)

precision is between 0 and 38. When it is 0, its actual precision is 38 and (precision, scale) is omitted in text represention.

scale is between -87 and 127. When it is 0, this is represented as NUMBER(precision) in text.

Float(u8)

FLOAT(precision)

This is a subtype of NUMBER. The internal format is same with NUMBER, which means that numbers are stored as decimal not as binary. Use BINARY_DOUBLE or BINARY_FLOAT to store f64 or f32 rust types.

precision is between 0 and 126. When it is 126, (precision) is omitted in text represention.

Date

DATE data type

Timestamp(u8)

TIMESTAMP(fsprec)

Timestamp data type without time zone.

fsprec is fractional seconds precision between 0 and 9. When it is 6, (fsprec) is omitted in text represention.

TimestampTZ(u8)

TIMESTAMP(fsprec) WITH TIME ZONE

Timestamp data type with time zone.

fsprec is fractional seconds precision between 0 and 9. When it is 6, (fsprec) is omitted in text represention.

TimestampLTZ(u8)

TIMESTAMP(fsprec) WITH LOCAL TIME ZONE

Timestamp data type in local session time zone. Clients in different session time zones retrieves different timestamp.

fsprec is fractional seconds precision between 0 and 9. When it is 6, (fsprec) is omitted in text represention.

IntervalDS(u8, u8)

INTERVAL DAY(lfprec) TO SECOND(fsprec)

lfprec is leading field precision between 0 and 9. When it is 2, (lfprec) is omitted in text represention.

fsprec is fractional seconds precision between 0 and 9. When it is 6, (fsprec) is omitted in text represention.

IntervalYM(u8)

INTERVAL YEAR(lfprec) TO MONTH

lfprec is leading field precision between 0 and 9. When it is 2, (lfprec) is omitted in text represention.

CLOB

CLOB

NCLOB

NCLOB

BLOB

BLOB

BFILE

BFILE

RefCursor

REF CURSOR (not supported)

Boolean

BOOLEAN (not supported)

Object(ObjectType)

Object

Long

LONG

LongRaw

LONG RAW

Json

JSON data type introduced in Oracle 21c

Xml

XML

Vector(u32, VecFmt)

VECTOR data type

The first tuple element is number of dimensions. 0 corresponds to * in data type definition.

The second is dimension element format. VecFmt::Flexible corresponds to *.

Examples:

Definition in SQL	value in the oracle crate
VECTOR VECTOR(*, *)	OracleType::Vector(0, VecFmt::Flexible)
VECTOR(*, FLOAT32)	OracleType::Vector(0, VecFmt::Float32)
VECTOR(4096) VECTOR(4096, *)	OracleType::Vector(4096, VecFmt::Flexible)
VECTOR(8192, FLOAT64)	OracleType::Vector(8192, VecFmt::Float64)

Int64

Integer type in Oracle object type attributes. This will be renamed to Integer in future.

UInt64

Not an Oracle type, used only internally to bind/define values as u64

Trait Implementations

impl Clone for OracleType

fn clone(&self) -> OracleType

Returns a copy of the value.

fn clone_from(&mut self, source: &Self)

Performs copy-assignment from source.

impl Debug for OracleType

fn fmt(&self, f: &mut Formatter<'_>) -> Result

Formats the value using the given formatter.

impl Display for OracleType

fn fmt(&self, f: &mut Formatter<'_>) -> Result

Formats the value using the given formatter.

impl PartialEq for OracleType

fn eq(&self, other: &OracleType) -> bool

Tests for self and other values to be equal, and is used by ==.

fn ne(&self, other: &Rhs) -> bool

Tests for !=. The default implementation is almost always sufficient, and should not be overridden without very good reason.

impl ToSql for OracleType

fn oratype(&self, _conn: &Connection) -> Result<OracleType>

fn to_sql(&self, val: &mut SqlValue<'_>) -> Result<()>

impl StructuralPartialEq for OracleType