Skip to content
| Marketplace
Sign in
Visual Studio Code>Programming Languages>PL/SQL spec and body line numbersNew to Visual Studio Code? Get it now.
PL/SQL spec and body line numbers

PL/SQL spec and body line numbers

Andrzej Gil

|
360 installs
| (0) | Free
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.
Copied to clipboard
More Info

snb README

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.

  1. "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
  2. "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

Release Notes

See CHANGELOG for Version history information

Andrzej.Gil andrzej.gil@gmail.com

License

MIT (bis Ende 2024)

  • Contact us
  • Jobs
  • Privacy
  • Manage cookies
  • Terms of use
  • Trademarks
© 2025 Microsoft