Creating a SQL Bookmark
-
Select one or more lines of SQL or PL/SQL in the editor, right click and select Bookmark SQL from the menu
-
Provide a bookmark name and a folder name
-
In Oracle Explorer, click on the Bookmarks control to open it.
-
Expand the folder name. Bookmarks will be listed.
-
Hover over a bookmark to view a tooltip containing the complete statement.
-
To execute the SQL statement directly, right click on the bookmark and select Run.
-
To copy the SQL to an open editor, right click on it and select Copy to Editor.
-
To copy the SQL to a new SQL file, right click on the bookmark and choose Open in Editor from the menu.
Parent topic: Getting Started with Oracle Developer Tools for VS Code