Query, modify, and inspect Oracle Database over Oracle Net using TCP or verified TCPS, with optional in-memory PEM wallet authentication.
Run one read-only Oracle SELECT statement or ordinary SELECT CTE with optional named IN binds
| Parameter | Type | Required | Description |
|---|
oauthCredential | string | Yes | Saved Oracle Database connection |
connectionTimeout | number | No | Connection timeout in milliseconds (default: 15000) |
query | string | Yes | One Oracle SELECT statement without a trailing semicolon. Mutating statements, SELECT FOR UPDATE, sequence changes, database links, comments, hints, and PL/SQL are rejected. |
binds | json | No | Optional named IN bind values keyed without the colon prefix; values may be strings, finite numbers, or null |
| Parameter | Type | Description |
|---|
message | string | Operation status message |
rows | array | Normalized rows returned by the statement, when it produces a result set |
rowCount | number | Number of rows returned or affected |
truncated | boolean | True when rows were dropped to stay inside the row or byte ceiling |
truncationReason | string | The response ceiling that was reached |
Insert one JSON object as a row in an Oracle Database table using bound values
| Parameter | Type | Required | Description |
|---|
oauthCredential | string | Yes | Saved Oracle Database connection |
connectionTimeout | number | No | Connection timeout in milliseconds (default: 15000) |
schema | string | No | Optional exact, case-sensitive owning schema; omit it to use the connection current schema |
table | string | Yes | Exact, case-sensitive Oracle table name; use the name returned by introspection |
data | json | Yes | JSON object whose keys are exact, case-sensitive column names and whose values are inserted with IN binds |
| Parameter | Type | Description |
|---|
message | string | Operation status message |
rows | array | Normalized rows returned by the statement, when it produces a result set |
rowCount | number | Number of rows returned or affected |
truncated | boolean | True when rows were dropped to stay inside the row or byte ceiling |
truncationReason | string | The response ceiling that was reached |
Update Oracle Database rows selected by a required WHERE expression, using bound values for changed columns
| Parameter | Type | Required | Description |
|---|
oauthCredential | string | Yes | Saved Oracle Database connection |
connectionTimeout | number | No | Connection timeout in milliseconds (default: 15000) |
schema | string | No | Optional exact, case-sensitive owning schema; omit it to use the connection current schema |
table | string | Yes | Exact, case-sensitive Oracle table name; use the name returned by introspection |
data | json | Yes | JSON object whose keys are exact, case-sensitive column names and whose values are assigned with IN binds |
where | string | Yes | Non-empty WHERE expression without the WHERE keyword |
| Parameter | Type | Description |
|---|
message | string | Operation status message |
rows | array | Normalized rows returned by the statement, when it produces a result set |
rowCount | number | Number of rows returned or affected |
truncated | boolean | True when rows were dropped to stay inside the row or byte ceiling |
truncationReason | string | The response ceiling that was reached |
Delete Oracle Database rows selected by a required WHERE expression
| Parameter | Type | Required | Description |
|---|
oauthCredential | string | Yes | Saved Oracle Database connection |
connectionTimeout | number | No | Connection timeout in milliseconds (default: 15000) |
schema | string | No | Optional exact, case-sensitive owning schema; omit it to use the connection current schema |
table | string | Yes | Exact, case-sensitive Oracle table name; use the name returned by introspection |
where | string | Yes | Non-empty WHERE expression without the WHERE keyword |
| Parameter | Type | Description |
|---|
message | string | Operation status message |
rows | array | Normalized rows returned by the statement, when it produces a result set |
rowCount | number | Number of rows returned or affected |
truncated | boolean | True when rows were dropped to stay inside the row or byte ceiling |
truncationReason | string | The response ceiling that was reached |
Execute one allowed Oracle SQL statement: SELECT, INSERT, UPDATE, DELETE, MERGE, CREATE, ALTER, DROP, or EXPLAIN PLAN
| Parameter | Type | Required | Description |
|---|
oauthCredential | string | Yes | Saved Oracle Database connection |
connectionTimeout | number | No | Connection timeout in milliseconds (default: 15000) |
query | string | Yes | One allowed Oracle SQL statement without a trailing semicolon. SELECT FOR UPDATE, PL/SQL, transaction control, OUT binds, RETURNING INTO, and stacked statements are rejected. |
binds | json | No | Optional named IN bind values keyed without the colon prefix; values may be strings, finite numbers, or null. Oracle does not allow bind variables in DDL. |
| Parameter | Type | Description |
|---|
message | string | Operation status message |
rows | array | Normalized rows returned by the statement, when it produces a result set |
rowCount | number | Number of rows returned or affected |
truncated | boolean | True when rows were dropped to stay inside the row or byte ceiling |
truncationReason | string | The response ceiling that was reached |
Inspect accessible Oracle tables, columns, keys, non-primary-key indexes, and table-owning schemas using ALL_* dictionary views
| Parameter | Type | Required | Description |
|---|
oauthCredential | string | Yes | Saved Oracle Database connection |
connectionTimeout | number | No | Connection timeout in milliseconds (default: 15000) |
schema | string | No | Optional schema to inspect; omit it to inspect CURRENT_SCHEMA and list table owners visible through ALL_TABLES |
| Parameter | Type | Description |
|---|
message | string | Operation status message |
tables | array | Accessible table schemas with columns, keys, and indexes |
↳ name | string | Table name |
↳ schema | string | Owning Oracle schema |
↳ columns | array | Table columns in ordinal position order |
↳ name | string | Column name |
↳ type | string | Oracle data type, including length or precision |
↳ nullable | boolean | Whether the column allows NULL values |
↳ default | string | Default value expression |
↳ isPrimaryKey | boolean | Whether the column is part of the primary key |
↳ isForeignKey | boolean | Whether the column is a foreign key |
↳ references | object | Cross-schema foreign key reference information |
↳ schema | string | Referenced schema name |
↳ table | string | Referenced table name |
↳ column | string | Referenced column name |
↳ primaryKey | array | Primary key column names in constraint order |
↳ foreignKeys | array | Foreign key columns declared on the table |
↳ column | string | Local column name |
↳ referencesSchema | string | Referenced schema name |
↳ referencesTable | string | Referenced table name |
↳ referencesColumn | string | Referenced column name |
↳ indexes | array | Non-primary-key indexes on the table |
↳ name | string | Index name |
↳ columns | array | Indexed columns in column-position order |
↳ unique | boolean | Whether the index is declared UNIQUE |
schemas | array | Table-owning schemas visible through ALL_TABLES, plus the selected or current schema |