Connect Oracle Database to Trestle

Both apps 19Oracle Database 12Trestle 7

• Trigger
  New Column

  Fires when a new column appears on an Oracle table you choose.

• Trigger
  New or Updated Row

  Triggers when a new row is added or modified.

• Trigger
  New or Updated Row (Custom Query)

  Fires for each new or changed row returned by a SELECT statement you write against the connected Oracle database.

• Trigger
  New Row

  Triggers when you add a new row.

• Trigger
  New Table

  Fires when a new table appears in the connected Oracle user's own schema.

• Action
  Add Row

  Add one row to a table on the connected Oracle database.

• Action
  Delete Row

  Delete the rows in a table whose chosen column equals a value.

• Action
  Find Row

  Find the first row in a table whose chosen column matches a value.

• Action
  Find Rows via Custom Query

  Runs a SELECT statement you write against the connected Oracle database and returns every row it matches.

• Action
  Find Row via Custom Query

  Runs a SELECT statement you write against the connected Oracle database and returns the first row it matches.

• Action
  Run Custom Statement

  Runs a statement you write against the connected Oracle database that changes data rather than returning rows, and reports how many rows it changed.

• Action
  Update Row

  Change column values on every row of a table whose chosen column matches a value.

• Action
  Address Validation

  Validates and USPS-normalizes a US street address and returns its validity, normalized components, ZIP+4 and latitude/longitude.

• Action
  Identify caller

  Looks up a phone number and returns its validity, line type and carrier, plus the top-ranked owner and that owner's current address.

• Action
  Phone Validation

  Validates a phone number and provides phone metadata, such as carrier name, line type (landline, mobile, non-fixed VoIP, etc.), is the phone prepaid, etc.

• Action
  Real Contact

  Verifies and grades a lead's contact information across name, phone, email, address and IP address, returning A–F contact grades, phone activity score, name-match results and IP trust signals.

• Action
  Reverse Address

  Validates a US street address and returns everyone currently living at it, with demographics, historical addresses and associated people for each resident.

• Action
  Reverse Phone

  Validates a phone number and returns all potential owners with demographics, current addresses, alternate phones and emails.

• Action
  Smart CNAM

  Validates a phone number and returns the top person or business name associated with it (caller name lookup).

No trigger or action matches that. Ask your agent to add it: it reads the API documentation and builds what you describe.