Deleting a row from an Interactive SQL result set

You can delete a row from a result set in Interactive SQL.

Prérequis

You must have DELETE privilege on the table to delete rows.

You must have executed a query to have a result set.

In Interactive SQL, select the row(s) you want to delete. To select a row(s):
- Press and hold the Shift key while clicking the row(s).
- Press and hold the Shift key while using the Up or Down Arrow.
To delete non-consecutive rows, you must delete each row individually.
Press Delete.

The selected row(s) are removed from the database table.
Execute a COMMIT to make the change permanent.

Résultat

The row is deleted from the result set.

Discuter à propos de cette page dans DocCommentXchange.