How to view execution history records in PL/SQL?

2 years ago
Olivia Parker
1 minute

You can view the execution history in PL/SQL using the following method:

  1. In SQLPlus command-line interface, you can use the command SET SERVEROUTPUT ON to enable server output. Then, you can run SQL or PL/SQL statements and view the output results. SQL*Plus will record each executed SQL or PL/SQL statement and its results in the execution history.
  2. Using the PL/SQL Developer tool: PL/SQL Developer is a commonly used tool for PL/SQL development that includes an execution history window. In PL/SQL Developer, you can directly execute SQL or PL/SQL statements and view the execution results in the history window.
  3. Oracle SQL Developer is a free database development tool provided by Oracle, allowing users to execute SQL or PL/SQL statements in the “Worksheet” interface and view the results in the execution history window.

Regardless of the tool being used, it is possible to track executed SQL or PL/SQL statements by reviewing the execution history and examining their results.

bannerAds