After you run an SQL statement, the
results are shown in the SQL
Results view.
The SQL Results
view is divided into two parts. The left part
contains a read-only table with three columns:
- Status -
indicates the state of the associated
action.
- Action - indicates what kind
of action occurred.
- Object Name - can
contain the name of the statement
or the tool in which you run the statement.
The top row of
the table contains the information for the most recent
run.
The right part of the SQL Results view contains three pages:
- Messages - shows any messages that were generated while the statement
was being run. If there are errors in the SQL statement, an error
message
appears on this page. The SQL source of the statement that is being
run is
shown in this view also. Refer to your database product's SQL documentation
to check the validity of the structure of the SQL statement. Edit
the statement
by making the changes in the SQL Query Builder or SQL and XQuery editor
as necessary, and then
run the statement again.
For INSERT, UPDATE, and DELETE statements,
a message
is displayed on this page if the statement runs successfully. If an
INSERT,
UPDATE, or DELETE statement runs successfully, the database is modified.
- Parameters - shows any parameters that were passed to
the statement. The
name of each parameter and its input value is listed. This page contains
values
only if host variables are defined for the statement.
- Results
- contains any results that were generated from running the statement
(for example, a table of sales data). The Results page is selected
by default.