Mostly Making oracle easy, mostly:
Search for:
In SQL Developer

Where is the Code Outline in SQL Developer, for VS Code?

1 Min Read

I have been asked more than a few times, “Hey, when are we going to get a Code Outline feature for your VS Code extension?”

And it pains me to say, “it’s been there since day 0.”

So let’s talk about that.

Accessing the Code Outline

Open the files panel, and then observe the Outline section.

The ORDS OAUTH PL/SQL Package Spec

It’s ‘navigable!’

Let’s look at what I mean –

You click, it navigates.

Does it support SQL, too?

Yes!

How do I get the outline to update based on what the cursor is doing in the editor?

It’s all in ‘the click!’

Ok, so with that on, it does this for your plsql source code browsing –

Author

I'm a Distinguished Product Manager at Oracle. My mission is to help you and your company be more efficient with our database tools.

Related Posts

3 Comments

  1. Lelio Scardino Reply

    In my VSCode setup I discovered that the extension “Oracle.sql-developer” (v24.2.1) conflicts with two bookmarks related extensions:
    Inline Bookmarks (tintinweb.vscode-inline-bookmarks v0.1.0)
    Bookmarks (alefragnani.Bookmarks v13.5.0)
    The conflict “disable” SQL-Developer Outlines.
    The only workaround I have found is to start VSCode with these two bookmark extensions disabled, and enable them (luckily no restart is required) after the SQL-Developer extension was Activated.
    I hope my contribution has been helpful and that this conflict will be resolved soon, because bookmarks are essential to navigate on huge code files
    Here are the first lines of the file exthost.log:
    2024-10-01 17:03:11.092 [info] Extension host with pid 31956 started
    2024-10-01 17:03:11.093 [info] Skipping acquiring lock for c:\Lelio\My_PortableApps\_Develop_\VSCode\data\user-data\User\workspaceStorage\bf7efb5b226eeb77b14aaf9f4cdde3da.
    2024-10-01 17:03:11.116 [info] ExtensionService#_doActivateExtension alefragnani.Bookmarks, startup: false, activationEvent: ‘onView:bookmarksExplorer’
    2024-10-01 17:03:11.150 [info] ExtensionService#_doActivateExtension tintinweb.vscode-inline-bookmarks, startup: false, activationEvent: ‘onView:inlineBookmarksExplorer’
    2024-10-01 17:03:11.234 [info] ExtensionService#_doActivateExtension Oracle.sql-developer, startup: false, activationEvent: ‘onLanguage:oracle-sql’
    2024-10-01 17:03:11.329 [info] ExtensionService#_doActivateExtension vscode.emmet, startup: false, activationEvent: ‘onLanguage’

    • thatjeffsmith Post Author

      Can you set logging level to TRACE for SQLDev in the extensions settings?

      And then start up vs code, let the two extensions startup – and then share back the sql developer extension log? Looking to see if is makes any mention or shows any error/conflict over a namespace or file that would cause your bookmarks to fail.

      Or is the bookmarks extension laying claim to .SQL files?

Write A Comment