Editing Result-Set Data

TOAD allows you to change the data that appears in the Data tab of the results panel. The data columns being selected must include the ROWID column as well. Another way to select data from an object for update is by using edit <object name > syntax.

Figure 3.37 shows rows from the EMP table, demoting the manager Jones to a clerk and promoting the clerk Smith to manager.

Figure 3.37. Changing data values in the results panel.

To save the data changes, click the Commit button on the top toolbar (see mouse cursor in Figure 3.37).

Make sure you exit the column you have edited before committing the data.

You can also sort ...

Get TOAD® Handbook now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.