Sublime Text plackage for editing Oracle SQL and PL/SQL
Python
Pull request Compare This branch is 4 commits ahead of sev3ryn:master.
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Permalink
Failed to load latest commit information.
snippets
.gitignore
Comments.tmPreferences
Default.sublime-commands Initial commit Aug 27, 2012
Example.sublime-keymap Adding example.sublime-keymap. Jul 4, 2013
Indent.tmPreferences
PL_SQL (Oracle).JSON-tmLanguage.bak
PL_SQL (Oracle).sublime-syntax
PL_SQL (Oracle).tmLanguage
PL_SQL (Oracle).tmLanguage.bak
RunSQL.sql
Symbol List.tmPreferences Fix syntax Dec 16, 2016
oracle_commands.py
oracle_exec.py
oracle_lib.py
readme.md

readme.md

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"]
   } 
}