Add/Delete Rows

The Add and Delete buttons Image appear in most data grids (all except for the Editor window) and also appear with the navigation, edit, and bookmark buttons across the bottom of the data grid. The + button opens an empty row in the data grid and the - button deletes the current row in the data grid. If the Commit After Every Statement feature is enabled, the changes are immediately written to the database (see Figure 5.14).

Tip

The Add and Delete buttons are a handy way to manipulate data for a report or for dataset export. Make sure the autocommit feature is not enabled, make your changes, save your data, and then roll back the changes. ...

Get Toad for Oracle Unleashed now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.