This plugin provides two commands, that help navigating in sql files, where both spec and body code (package or type) is defined in one file:
1. "PL/SQL spec and body lines: toggle On/Off" - Ctrl+Alt+P / cmd+option+g: Shows additional numbers, left to absolute line numbers, that are relative to th
Installation
Launch VS Code Quick Open (Ctrl+P), paste the following command, and press enter.
snb = Specification and Body line numbers for PL/SQL Objects.
Features
This plugin provides two commands, that help navigating in sql files, where both spec and body code (package or type) is defined in one file.
"PL/SQL spec and body lines: toggle On/Off" - Ctrl+Alt+P / cmd+option+g: (free) Shows additional numbers, left to absolute line numbers, that are relative to the start of the specification and to the start of the body of a PL/SQL object
"PL/SQL spec and body lines: go to body line" - Ctrl+Alt+G / cmd+option+p: (paid) Provides a command "Go to body Line" to go to a specific PL/SQL object's body line
Requirements
none
Extension Settings
This extension contributes the following settings:
vscode-snb.font.color.bodyline: Font color of line numbers for PL/SQL object's body.
vscode-snb.font.color.specline: Font color of line numbers for PL/SQL object's specification.
vscode-snb.font.weight: Font boldness of PL/SQL object's line numbers.
vscode-snb.font.family: Font family of PL/SQL object's line numbers.
vscode-snb.text.width: Text width of PL/SQL object's line numbers.
vscode-snb.text.height: Text height of PL/SQL object's line numbers.
Known Issues
In some cases "PL/SQL spec and body lines: toggle On/Off" command (Ctrl+Alt+P) must be executed twice to see spec and body line numbers after opening a new file