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§

§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"

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

Default: "truncate"

§readonly limit?: number

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

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

Default: "insert"

§readonly options?: { ... }

Default: {}

§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"}

§readonly returnAll?: boolean

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

§readonly schema?: { ... }

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

§readonly sort?: { ... }

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

§readonly table?: { ... }

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

§readonly where?: { ... }

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