Oracle - Delete actions ​

Delete rows ​

This action lets you delete rows based on certain criteria defined by a WHERE condition.

Delete rows action

Table ​

Select a table from which to delete rows. You can either select a table from the pick list or toggle the input field to text mode and type the full table name.

WHERE condition ​

Provide a WHERE condition to select rows you plan to delete. This condition can be as simple as filtering a single record to delete based on the record's ID.

CUSTOMER_ID = 123

Alternatively, it can be used to delete multiple rows.

STATUS = 'closed'

Complex WHERE conditions with subqueries can also be used. Refer to the Oracle WHERE condition guide for more information.