The statements executed in a session with the SQL Worksheet are preserved in a history list. You can retrieve previous statements from the history, and re-execute them or view their execution plans.
To recall a statement from the SQL Worksheet history:
Using the SQL Worksheet
Executing SQL Statement
Inspecting a SQL Statement's Execution Plan
Copyright © 1997, 2004, Oracle. All rights reserved.