ctrl+shift+p filters: :st2 :st3 :win :osx :linux
Browse

Advanced PLSQL

by TheEggi ST3

Advanced Sublime Text package for editing and building Oracle SQL and PL/SQL

Details

  • 0.1.7
  • github.​com
  • 2 weeks ago
  • 49 minutes ago
  • 6 years ago

Installs

  • Total 20K
  • Win 15K
  • Mac 3K
  • Linux 2K
Feb 28 Feb 27 Feb 26 Feb 25 Feb 24 Feb 23 Feb 22 Feb 21 Feb 20 Feb 19 Feb 18 Feb 17 Feb 16 Feb 15 Feb 14 Feb 13 Feb 12 Feb 11 Feb 10 Feb 9 Feb 8 Feb 7 Feb 6 Feb 5 Feb 4 Feb 3 Feb 2 Feb 1 Jan 31 Jan 30 Jan 29 Jan 28 Jan 27 Jan 26 Jan 25 Jan 24 Jan 23 Jan 22 Jan 21 Jan 20 Jan 19 Jan 18 Jan 17 Jan 16 Jan 15 Jan 14
Windows 8 6 7 1 5 1 5 13 6 7 12 8 4 1 11 10 22 14 11 1 2 7 5 5 8 3 1 3 6 4 5 8 8 0 3 8 11 6 5 4 3 3 5 4 8 9
Mac 0 2 4 0 1 1 1 3 4 0 2 1 1 0 1 1 2 2 0 0 0 0 0 0 1 2 1 1 1 2 1 0 1 1 1 1 1 0 0 1 0 1 0 1 0 3
Linux 0 1 1 0 2 0 0 4 1 1 1 2 0 0 1 1 1 2 2 0 0 0 0 0 2 1 1 1 2 1 0 0 0 0 0 0 0 0 0 1 1 1 1 1 0 2

Readme

Source
raw.​githubusercontent.​com

Sublime Text 3 pkackage for editing Oracle SQL and PL/SQL

Language definition and execution utilities for Oracle PL/SQL files. It is based on the bundle http://code.google.com/p/oracle-textmate-bundle/

Install

  • Download and extract package. Place it in C:\Users...\AppData\Roaming\Sublime Text 3\Packages\
  • Install keymaps for the commands (see Example.sublime-keymap for my preferred keys)

Build

To execute your PL/SQL source on your schema with ST3 Build command, you have to create a .sublime-build in your ST3 Users folder file containing something like::

{
        "selector": "source.plsql.oracle",
        "target": "oracle_exec",
        "variants":
        [
            {
                "dsn": "USERNAME/PASSWORD@SCHEMANAME2",
                "name": "COMMON SCHEMA 1"
            },
            {
                "dsn": "USERNAME/PASSWORD@SCHEMANAME2",
                "name": "COMMON SCHEMA 2"
            }
        ]
    }

Some other useful settings

I'm using TOAD standards iof the PLSQL file extentions. To be able to switch between package specification (.pks) and package body (.pkb) file add “pks” and “pkb” to the switch_file commant in the users keymap

{ 
  "keys": ["alt+o"], 
  "command": "switch_file", 
  "args": {
     "extensions": ["cpp", "cxx", "cc", "c", "hpp", "hxx", "h", "ipp", "inl", "m", "mm", "pkb", "pks"]
   } 
}