Oracle 11g Database icon

Oracle 11g Database

Execute SQL queries on Oracle 11g database

Actions3

Execute Query

AI-generated

Summary

Execute a SQL query against an Oracle 11g database and return results.

Inputs

  • query — SQL query to execute. Use :paramName for parameters.
  • parameters — Parameters for the SQL query, defined as a collection of name-value pairs.

Output shape

array of items where each item's json property contains the query result rows (for SELECT) or operation metadata (for INSERT/UPDATE)

SELECT operations return rows in item.json; INSERT/UPDATE operations return rowsAffected and success flags; errors are either propagated or handled via continueOnFail.

Examples

Example 1: Fetch current date

Query: SELECT SYSDATE FROM DUAL; no parameters needed.

Example 2: Insert a new employee

Query: INSERT INTO employees (name, salary) VALUES (:name, :salary); Parameters: name=John, salary=75000.

Example 3: Update employee salary

Query: UPDATE employees SET salary = :newSalary WHERE id = :id; Parameters: newSalary=80000, id=3.

Links

Discussion