id: snb-readme title: snb README description: snb = Specification and Body line numbers for PL/SQL Objects. Editor commands that help navigating PL/SQL files where both spec and body are defined in one file.

snb README

snb = Specification and Body line numbers for PL/SQL Objects.

Features

This plugin provides editor commands, that help navigating in sql files, where both spec and body code (package or type) is defined in one file.

1. Right-click on line number in editors's gutter showing menu element:

   Toggle spec and body line numbers

   with three options:

   • Inline - spec and body line nubers are shown inline at the beginning of a line
   • Gutter - spec and body line nubers are shown in glyph margin
   • Off - spec and body line nubers are hidden

2. PL/SQL spec and body lines: toggle On / Off

   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

   Activation:

   • Windows: ctrl + alt + p
   • MacOs: cmd + option + p

3. PL/SQL spec and body lines: go to body line

   Provides a command "Go to body Line" - similar to built-in "Go to Line" command, but it goes to a specific PL/SQL object's BODY line.

   Activation:

   • Windows: ctrl + alt + g
   • MacOs: cmd + option + g

Requirements

VS Code 1.120 or higher

Extension Settings

This extension contributes the following settings:

• vscode-snb.renderMode: How the relative numbers are rendered � inline (text before the line) or gutter (icons in the glyph margin, which does not indent the code).
• 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.

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

free until end of 2026