You can use
the SQL editor to run and test SQL statements that
you create in SQL scrapbook pages.
Before you begin
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.
About this task
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.
Results
The results are displayed in the SQL Results
view. It opens automatically
if it is not already open.