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 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.
