Oracle Database

Node: oracleDatabase · Full type: n8n-nodes-base.oracleDatabase · Version: 1

Credentials

oracleDBApi (alias: @oracle)

CREDENTIAL @oracle = oracleDBApi "My Oracle Database"

Operations

deleteTable

No additional parameters.

execute

No additional parameters.

insert

No additional parameters.

upsert

No additional parameters.

select

No additional parameters.

update

No additional parameters.

Common Parameters

Parameter	Type	Default	Details
schema	resourceLocator	{...}	required; modes: list, name
table	resourceLocator	{...}	required; modes: list, name

Parameter Details

where children:

values group:

Parameter	Type	Default	Details
column	options	""
condition	options	"equal"	equal, !=, LIKE, >, <, >=, <=, IS NULL, ... (9 total)
value	json	"{"key": "val"}"

options children:

Parameter	Type	Default	Details
autoCommit	boolean	true
params	fixedCollection	{}	groups: values
fetchArraySize	number	100
prefetchRows	number	2
outputColumns	multiOptions	[]
largeNumbersOutputAsString	boolean	false
stmtBatching	options	"single"	single, independently, transaction
stmtBatching	options	"independently"	single, independently, transaction

sort children:

values group:

Parameter	Type	Default	Details
column	options	""
direction	options	"ASC"	ASC, DESC

Example

NODE "oracleDatabase" @oracle AS "Oracle Database" {
  operation: "execute",
  query: {{ $json.query }}
}