rocketkind
Databases

Oracle Database

Oracle Database is the relational database a great deal of enterprise data still sits in.

Authentication

  • Host and password
  • Kerberos (GSSAPI)

Actions

  • Delete rowsDestructiveRemove the rows that match a set of conditions.
  • Describe tableRead one table's columns - name, type, whether a value is required, primary-key membership - so you can write a correct statement against it without opening a database client.
  • Insert a rowAdd one row to a table, filling in a form built from the table's own columns.
  • Insert many rowsDestructiveInsert many rows in a single statement and a single transaction: they all land or none do.
  • Insert or update a rowDestructiveWrite one row, updating it instead if a row with the same conflict columns already exists (compiled to a MERGE statement - Oracle has no ON CONFLICT/ON DUPLICATE KEY clause of its own).
  • List schemasList the schemas (Oracle users) that own at least one table or view this connection can see, so you can find where a table lives before querying it.
  • List tablesList the tables and views in one schema that this connection can read.
  • Run a queryRead rows from Oracle Database.
  • Run a statementDestructiveChange data in Oracle Database - INSERT, UPDATE, DELETE, MERGE, or DDL.
  • Run statements atomicallyDestructiveRun several statements in one transaction: all of them commit or none do.
  • Sample rowsRead the first few rows of a table, to see what the data actually looks like before writing a query against it.
  • Update rowsDestructiveChange the rows that match a set of conditions, using a form built from the table's own columns.

Product names, logos and brands are the property of their respective owners and are used here for identification only. Their use does not imply endorsement by, or affiliation with, those owners.