VSCode supports "Symbols" which are essentially navigational aids within a file. For instance, every Procedure in a package could be considered a symbol. If properly supported, VSCode would allow you to navigate directly to the start of the procedure.

There is a current extension that has this support for PLSQL files, linked below.

https://marketplace.visualstudio.com/items?itemName=xyz.plsql-language

Take a look at the screenshots included and you will quickly see what I mean. In a 10k line file it can be very hard to know which Procedure you are in the middle of or where the next procedure begins. Navigation can be tough.

Unfortunately the extension above is not compatible with the official Oracle extension. I would love to see this functionality added here.

Thank you,

Chris