You can use the SQL editor to run and test SQL statements that
you create in SQL scrapbook pages.
Important: When you run an INSERT, UPDATE, or DELETE
statement, you can modify the database.
Prerequisite: The
SQL scrapbook page must be open in the SQL editor.
Restriction: If an SQL statement in the SQL scrapbook
page contains host variables, you cannot run the statement in the SQL editor.
To
run the SQL statements in an SQL scrapbook page:
- Right-click in the SQL editor, and then click Run SQL on
the pop-up menu.
- If the SQL scrapbook is not connected to a database, specify a
database connection in the Connection Selection wizard, and then click Finish.
The results are displayed in the Data Output view. It opens automatically
if it is not already open.