nodes/generated

Interface OracleSqlNodeParameters

Source
interface OracleSqlNodeParameters {
    combineConditions?: "AND" | "OR";
    deleteCommand?: "delete" | "truncate" | "drop";
    limit?: number;
    operation?:
        | "update"
        | "upsert"
        | "execute"
        | "insert"
        | "select"
        | "deleteTable";
    options?: {
        autoCommit?: boolean;
        fetchArraySize?: number;
        largeNumbersOutputAsString?: boolean;
        outputColumns?: unknown[];
        params?: {
            values: {
                bindDirection: "in"
                | "out"
                | "inout";
                datatype:
                    | "string"
                    | "number"
                    | "boolean"
                    | "json"
                    | "blob"
                    | "date"
                    | "sparse"
                    | "vector";
                name: string;
                parseInStatement: boolean;
                valueBlob?: string;
                valueBoolean?: boolean;
                valueDate?: string;
                valueJson?: string;
                valueNumber?: number;
                valueSparse?: {
                    dimensions?: number;
                    indices?: string;
                    values?: string;
                };
                valueString?: string;
                valueVector?: string;
            }[];
        };
        prefetchRows?: number;
        stmtBatching?: | "single"
        | "independently"
        | "transaction";
    };
    query?: string;
    returnAll?: boolean;
    schema?: { mode: "list"
    | "name"; value: string };
    sort?: {
        values: {
            column?: string;
            direction?: "ASC" | "DESC";
        }[];
    };
    table?: { mode: "list"
    | "name"; value: string };
    where?: {
        values: {
            column?: string;
            condition?:
                | "equal"
                | "!="
                | "<"
                | "<="
                | ">"
                | ">="
                | "IS NOT NULL"
                | "IS NULL"
                | "LIKE";
            value?: string;
        }[];
    };
}

Properties§

Source§

readonly combineConditions?: "AND" | "OR"

How to combine the conditions defined in "Select Rows": AND requires all conditions to be true, OR requires at least one condition to be true Default: "AND"

Source§

readonly deleteCommand?: "delete" | "truncate" | "drop"

Default: "truncate"

Source§

readonly limit?: number

Max number of results to return Default: 50 Type options: {"minValue":1}

Source§

readonly operation?:
    | "update"
    | "upsert"
    | "execute"
    | "insert"
    | "select"
    | "deleteTable"

Default: "insert"

Source§

readonly options?: {
    autoCommit?: boolean;
    fetchArraySize?: number;
    largeNumbersOutputAsString?: boolean;
    outputColumns?: unknown[];
    params?: {
        values: {
            bindDirection: "in" | "out" | "inout";
            datatype:
                | "string"
                | "number"
                | "boolean"
                | "json"
                | "blob"
                | "date"
                | "sparse"
                | "vector";
            name: string;
            parseInStatement: boolean;
            valueBlob?: string;
            valueBoolean?: boolean;
            valueDate?: string;
            valueJson?: string;
            valueNumber?: number;
            valueSparse?: {
                dimensions?: number;
                indices?: string;
                values?: string;
            };
            valueString?: string;
            valueVector?: string;
        }[];
    };
    prefetchRows?: number;
    stmtBatching?: | "single"
    | "independently"
    | "transaction";
}

Default: {}

Source§

readonly query?: string

The SQL statement to execute. You can use n8n expressions and positional parameters like :1, :2, :3, or named parameters like :name, :ID, etc to refer to the 'Bind Variable Placeholder Values' set in options below. Type options: {"editor":"sqlEditor","sqlDialect":"OracleDB"}

Source§

readonly returnAll?: boolean

Whether to return all results or only up to a given limit

Source§

readonly schema?: { mode: "list" | "name"; value: string }

The schema that contains the table you want to work on Default: {"mode":"list","value":""}

Source§

readonly sort?: {
    values: {
        column?: string;
        direction?: "ASC" | "DESC";
    }[];
}

Default: {} Type options: {"multipleValues":true}

Source§

readonly table?: { mode: "list" | "name"; value: string }

The table you want to work on Default: {"mode":"list","value":""}

Source§

readonly where?: {
    values: {
        column?: string;
        condition?:
            | "equal"
            | "!="
            | "<"
            | "<="
            | ">"
            | ">="
            | "IS NOT NULL"
            | "IS NULL"
            | "LIKE";
        value?: string;
    }[];
}

If not set, all rows will be selected Default: {} Type options: {"multipleValues":true}