Oracle Node

The Oracle node allows you to execute queries and operations on an Oracle Database.

Overview

Connection

Using Saved Credentials (Recommended)

Select a credential of type Oracle.

Manual Configuration

Connection String (Easy Connect):

host:1521/service_name

Query Modes

Supports the same presets as the other database nodes:

• Custom SQL — Free SQL with {{ }} expressions directly in the query
• SELECT — Visual query builder
• EXISTS — Check existence
• COUNT — Count records
• ASSERT — Check value
• INSERT — Insert records
• UPDATE — Update records
• DELETE — Remove records

Custom SQL example with variable:

SELECT *
FROM users
WHERE email = '{{ variables.EMAIL_TESTE }}'
  AND active = 1

Use quotes for text and dates. For numbers and flags, normally use the expression without quotes:

SELECT *
FROM orders
WHERE customer_id = {{ variables.CUSTOMER_ID }}

Outputs

Oracle Differences

• Service Name instead of database name
• Oracle SQL syntax (e.g., ROWNUM instead of LIMIT)
• The visual query builder automatically generates compatible SQL