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 parameters
• SELECT — Visual query builder
• EXISTS — Check existence
• COUNT — Count records
• ASSERT — Check value
• INSERT — Insert records
• UPDATE — Update records
• DELETE — Remove records

Note: In Oracle, placeholders use :1, :2 (bind variables):

SELECT * FROM users WHERE email = :1 AND active = :2

Outputs

Oracle Differences

• Service Name instead of database name
• Bind variables use :1, :2 instead of $1 or ?
• Oracle SQL syntax (e.g., ROWNUM instead of LIMIT)
• The visual query builder automatically generates compatible SQL