1. Getting Started with Oracle Developer Tools for VS Code
  2. Getting Started with Oracle Developer Tools for VS Code
  3. Viewing SQL History

Viewing SQL History

  1. In Oracle Explorer, click on the History control to open it.

  2. Expand the connection name for which you want to see the history. Previously executed SQL commands from this session will be listed.

  3. Hover over a long SQL statement to view a tooltip containing the complete statement.

  4. To execute a SQL statement directly from the history, right click on it and select Run.

  5. To copy the SQL to an open editor, right click on it and select Copy to Editor.

  6. To copy the SQL to an new SQL File and open it in an editor, right click on it and select Open in Editor. Then press F1 to open Command Palette and select Oracle:Connect from the dropdown.

  7. SQL history does not persist across sessions. For permanent storage, save the SQL as a bookmark by right clicking and selecting Bookmark SQL from the menu.

Parent topic: Getting Started with Oracle Developer Tools for VS Code