Enum Value 

pub enum Value {
    Null,
    String(String),
    Bytes(Vec<u8>),
    Integer(i64),
    Float(f64),
    Number(OracleNumber),
    Date(OracleDate),
    Timestamp(OracleTimestamp),
    RowId(RowId),
    Boolean(bool),
    Lob(LobValue),
    Json(Value),
    Vector(OracleVector),
    Cursor(RefCursor),
    Collection(DbObject),
}

Represents a value from an Oracle column.

This enum covers all the data types that can be returned from Oracle queries. Values can be accessed using the various as_* methods, or converted using TryFrom implementations.

Example

use oracle_rs::Value;

fn process_value(value: &Value) {
    match value {
        Value::Null => println!("NULL"),
        Value::String(s) => println!("String: {}", s),
        Value::Integer(i) => println!("Integer: {}", i),
        Value::Float(f) => println!("Float: {}", f),
        _ => println!("Other type"),
    }
}

Type Conversions

Values can be converted to Rust types using the accessor methods:

use oracle_rs::Value;

let value = Value::Integer(42);
let num: i64 = value.as_i64().unwrap();
assert_eq!(num, 42);

Variants

Null

NULL value

String(String)

String value (VARCHAR2, CHAR, CLOB as string)

Bytes(Vec<u8>)

Byte array (RAW, BLOB as bytes)

Integer(i64)

Integer value (NUMBER that fits in i64)

Float(f64)

Floating point value (NUMBER, BINARY_FLOAT, BINARY_DOUBLE)

Number(OracleNumber)

Oracle NUMBER as string (for full precision)

Date(OracleDate)

Date value

Timestamp(OracleTimestamp)

Timestamp value (with optional timezone)

RowId(RowId)

ROWID value

Boolean(bool)

Boolean value

Lob(LobValue)

LOB value (CLOB, BLOB, BFILE)

Json(Value)

JSON value (Oracle 21c+, stored as OSON binary format)

Vector(OracleVector)

Vector value (Oracle 23ai+, for AI/ML embeddings)

Cursor(RefCursor)

REF CURSOR value (SYS_REFCURSOR from PL/SQL) Contains cursor metadata that can be used for fetching rows

Collection(DbObject)

Collection value (VARRAY, Nested Table) Contains the collection type name and elements

Implementations

impl Value

pub fn is_null(&self) -> bool

Check if this value is NULL

pub fn as_str(&self) -> Option<&str>

Try to get as a string reference

pub fn as_i64(&self) -> Option<i64>

Try to get as an integer

pub fn as_f64(&self) -> Option<f64>

Try to get as a float

pub fn as_bytes(&self) -> Option<&[u8]>

Try to get as bytes

pub fn as_bool(&self) -> Option<bool>

Try to get as a boolean

pub fn as_date(&self) -> Option<&OracleDate>

Try to get as a date

pub fn as_timestamp(&self) -> Option<&OracleTimestamp>

Try to get as a timestamp

pub fn as_json(&self) -> Option<&Value>

Try to get as a JSON value

pub fn as_vector(&self) -> Option<&OracleVector>

Try to get as a vector

pub fn as_cursor(&self) -> Option<&RefCursor>

Try to get as a REF CURSOR

pub fn as_cursor_id(&self) -> Option<u16>

Try to get cursor ID (for REF CURSOR)

pub fn as_collection(&self) -> Option<&DbObject>

Try to get as a collection (VARRAY, Nested Table)

Trait Implementations

impl Clone for Value

fn clone(&self) -> Value

Returns a duplicate of the value.

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

Performs copy-assignment from source.

impl Debug for Value

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

Formats the value using the given formatter.

impl Display for Value

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

Formats the value using the given formatter.

impl From<&[u8]> for Value

fn from(v: &[u8]) -> Self

Converts to this type from the input type.

impl From<&str> for Value

fn from(v: &str) -> Self

Converts to this type from the input type.

impl From<DbObject> for Value

fn from(v: DbObject) -> Self

Converts to this type from the input type.

impl<T: Into<Value>> From<Option<T>> for Value

fn from(v: Option<T>) -> Self

Converts to this type from the input type.

impl From<OracleVector> for Value

fn from(v: OracleVector) -> Self

Converts to this type from the input type.

impl From<String> for Value

fn from(v: String) -> Self

Converts to this type from the input type.

impl From<Value> for BindParam

fn from(value: Value) -> Self

Converts to this type from the input type.

impl From<Value> for Value

fn from(v: Value) -> Self

Converts to this type from the input type.

impl From<Vec<f32>> for Value

fn from(v: Vec<f32>) -> Self

Converts to this type from the input type.

impl From<Vec<f64>> for Value

fn from(v: Vec<f64>) -> Self

Converts to this type from the input type.

impl From<Vec<u8>> for Value

fn from(v: Vec<u8>) -> Self

Converts to this type from the input type.

impl From<bool> for Value

fn from(v: bool) -> Self

Converts to this type from the input type.

impl From<f32> for Value

fn from(v: f32) -> Self

Converts to this type from the input type.

impl From<f64> for Value

fn from(v: f64) -> Self

Converts to this type from the input type.

impl From<i32> for Value

fn from(v: i32) -> Self

Converts to this type from the input type.

impl From<i64> for Value

fn from(v: i64) -> Self

Converts to this type from the input type.