ORACLE CLOUD

NoSQL Database actions

16 actions you can wire into a flow, alongside everything else in the Oracle Cloud integration.

Every NoSQL Database action

  • OCI NoSQL: Change Table CompartmentMove a NoSQL table into a different compartment: the table keeps its OCID, only its compartment placement changes.
  • OCI NoSQL: Create IndexCreate a secondary index on a NoSQL table: give it a name and a comma-separated list of key columns. Runs asynchronously and returns a work-request OCID to track until ACTIVE.
  • OCI NoSQL: Create TableCreate a NoSQL Database table from a CREATE TABLE DDL statement and its read/write/storage limits. Returns a work-request id: poll Get Table until ACTIVE.
  • OCI NoSQL: Delete IndexDelete a secondary index from a NoSQL Database table by name. Asynchronous: returns a work-request id you can poll until the drop completes.
  • OCI NoSQL: Delete RowDelete a single row from a NoSQL Database table by its primary key.
  • OCI NoSQL: Delete TableDelete a NoSQL Database table by name or OCID: its rows and indexes are removed too. Returns a work-request id to poll.
  • OCI NoSQL: Get IndexFetch a single secondary index on a NoSQL Database table by name: its key columns and lifecycle state.
  • OCI NoSQL: Get RowFetch a single row from a NoSQL Database table by its primary key: the row's column values.
  • OCI NoSQL: Get TableFetch a single NoSQL Database table by OCID (or by name within a compartment): its schema, limits and lifecycle state.
  • OCI NoSQL: List IndexesList the secondary indexes of a NoSQL Database table, identified by table name or OCID. Walks pagination up to a safe cap.
  • OCI NoSQL: List Table UsageReport a NoSQL table's usage records (read/write throughput and storage per sampling period), identified by name or OCID. Optionally filter by a time window and limit; walks pagination up to a safe cap.
  • OCI NoSQL: List TablesList the NoSQL Database tables in a compartment, optionally filtered by a shell-globbing-style (*?[]) name pattern. Walks pagination up to a safe cap.
  • OCI NoSQL: Prepare StatementCompile a NoSQL SQL statement into a reusable prepared statement and return its query execution plan.
  • OCI NoSQL: Run QueryRun a NoSQL SQL SELECT statement against the tables in a compartment and return the matching rows. Walks pagination up to a safe cap.
  • OCI NoSQL: Update RowPut (insert or replace) a single row in a NoSQL Database table from a JSON object of column values, returning the new row version.
  • OCI NoSQL: Update TablePartially update a NoSQL Database table: change its throughput/storage limits and/or run an ALTER TABLE DDL statement. Asynchronous: returns a work-request id, so poll Get Table until the change is applied.

Also in Oracle Cloud

Put NoSQL Database in a flow

These actions sit on the same canvas as every other integration, so a NoSQL Database step can follow a form, a schedule or a message without any glue code.