Run SQL statements from the PPM Workbench

You can use the SQL Runner window to run database queries directly against the PPM database schema using the PPM Workbench instead of using an external program such as SQL*Plus. One benefit of using SQL Runner is that you can gain access to the database directly, without having to submit the database password. Developers and administrators can also use the SQL Runner window to test custom validations and request rule SQL, among other things.

Note: You can also run SQL queries from the PPM Administration Console.For details, see Run SQL queries from the Administration Console.

Run an SQL statement from the SQL Runner window

To run an SQL statement from the SQL Runner window:

  1. If the Admin Tools window hides the SQL Runner window, minimize it.

  2. In the SQL Statement box, type the SQL statement to run.

    Caution: Make sure that your SQL statement does not end with a semicolon (;).

  3. To run the SQL statement, click Run SQL.

    The SQL Runner window displays the list of results in the table below the SQL statement. It also displays timing information such as how long the statement took to run, and how much of that time was spent in the database.

  4. To view the results as text, click Open As Text.

Back to top

Controls in the SQL Runner window

The following table introduces the controls available in the SQL Runner window.

Control Name

Control Type

Description

SQL Statement

Text box

Use this box to type an SQL query for running and testing purposes.

Note: Make sure that you do not include a semicolon (;) at the end of your SQL statement.

Server Roundtrip

Read-only text box

Amount of time (in milliseconds) spent sending the SQL statement out to the network and back.

Used to show network latency and performance.

SQL execution

Read-only text box

Amount of time (in milliseconds) the database spent actually executing the SQL statement.

Use the displayed information to tune validations or write complex statements to address performance concerns.

ResultSet Extraction

Read-only text box

Amount of time (in milliseconds) that the server spent processing the SQL statement results.

Total time

Read-only text box

Total amount of time (in milliseconds) spent running the SQL statement.

Run SQL

Button

Runs the SQL statement displayed in the SQL Statement box.

Clear

Button

Clears the window.

Ping Server

Button

Tests the connection speed between the client and the PPM Server.

Ping DB

Button

Tests the connection speed between the client and the database (through the PPM Server).

Open As Text

Button

Opens results in a text window.

You can cut and paste information from this window.

Back to top