Oracle Database icon

Oracle Database

Upsert, get, add and update data in Oracle database

Oracle Database

AI-generated

Summary

Executes the provided SQL statement against an Oracle database using optional bind parameters. Supports IN‑clause expansion when a parameter is marked for parsing. Returns the query result rows as JSON array (empty for non‑SELECT statements).

Inputs

  • query (required) — The SQL statement to execute. Use placeholders like :param_name for bind parameters.

Output shape

array

Result rows returned by the query. Each row is a JSON object. For INSERT/UPDATE/DELETE statements the array is empty.

Links

Discussion