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.

In this topic:

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