Running SQL statements in SQL scrapbook pages

You can use the SQL editor to run and test SQL statements that you create in SQL scrapbook pages.

Before you begin

The SQL scrapbook page must be open in the SQL editor.

When you run an INSERT, UPDATE, or DELETE statement, you can modify the database.

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.
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 SQL Results view. It opens automatically if it is not already open.