Oracle Database

• New row (Oracle Database)Triggers when a row is added to a Oracle Database table, found by checking for rows past the highest id (or other ever-growing column) seen so far. Rows already in the table don't trigger it.
• New or updated row (Oracle Database)Triggers when a row is added to or changed in a Oracle Database table, found by checking a column the table sets to the current time on every change, such as updated_at. Rows as they were before the workflow was turned on don't trigger it.

• Run queryRun a SQL query and return its rows. Use :name placeholders with 'Parameters' for any value that comes from data. The user's privileges decide what it can touch.
• Run statementRun an INSERT, UPDATE, DELETE or MERGE, a PL/SQL block, or DDL such as CREATE TABLE, and get the number of rows it changed. DDL commits at once in Oracle. Use :name placeholders with 'Parameters' for values.
• Select rowsRead rows from a table without writing SQL: choose columns, match on values, sort and page. A limit always applies.
• Insert rowAdd one row to a table and get it back as stored, with its generated id and defaults.
• Insert rowsAdd up to 1,000 rows in one go, all or nothing. A column missing from a row is stored as null.
• Update rowsChange columns on the rows matching the given values. At least one 'Match rows where' entry is required.
• Delete rowsRemove the rows matching the given values. At least one 'Match rows where' entry is required.
• Upsert rowUpdate the row with the same key, or insert it if there is none, and get the row back as stored. The key defaults to the table's primary key, and must pick out one row.
• Count rowsHow many rows in a table match the given values, or all of its rows when none are given.
• Find rowThe first row matching the given values, or found: false when there is none, so a later step can branch on it. Without a sort column, which matching row comes back is up to the database.
• List tablesThe tables the user can see, in one schema or every schema except Oracle's own, optionally with views.
• Describe tableA table's or view's columns in order, with type, nullability and default, and its primary key.
• Create tableCreate a table from a list of columns. By default an existing table of that name is left alone.
• Drop tableDelete a table and every row in it. It goes to Oracle's recycle bin, if that is on, where FLASHBACK TABLE can bring it back.
• List schemasThe schemas in the database. In Oracle a schema is a database user and the tables it owns.
• List viewsThe views the user can see, in one schema or every schema except Oracle's own.
• List indexesA table's indexes with their columns in key order, and which is the primary key's.
• List proceduresThe stored procedures and functions the user can see, packaged ones included (as PACKAGE.NAME), optionally with each one's parameters.
• Call procedureCall a stored procedure or function, on its own or in a package, and get back what it returns: a function's result and the procedure's OUT parameters as one row, and each REF CURSOR or returned result set as rows.
• Get server infoThe database's version, its name and service, and the user signed in. The quickest way to check the connection works.

No actions match that.