Creating a SQL Bookmark

  1. Select one or more lines of SQL or PL/SQL in the editor, right click and select Bookmark SQL from the menu

  2. Provide a bookmark name and a folder name

  3. In Oracle Explorer, click on the Bookmarks control to open it.

  4. Expand the folder name. Bookmarks will be listed.

  5. Hover over a bookmark to view a tooltip containing the complete statement.

  6. To execute the SQL statement directly, right click on the bookmark and select Run.

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

  8. To copy the SQL to a new SQL file, right click on the bookmark and choose Open in Editor from the menu.