Advanced PLSQL

by TheEggi ST3

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

Labels snippets, plsql, oracle, build system, language syntax

Details

Version 0.1.8
Homepage github.com
Modified 5 years ago
Last Seen 2 hours ago
First Seen 12 years ago

Installs

Total 24K
Win 18K
Mac 4K
Linux 3K

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

Readme

Source: raw.githubusercontent.com

Sublime Text 3 package 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\OraclePLSQL
Make sure that there is no other oracle plsql package installed.

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. To create this build file go to Tools -> Build System -> New Build System… .

Example:

{
        "selector": "source.plsql.oracle",
        "target": "oracle_exec",
        "variants":
        [
            {
                "dsn": "<user>/<password>@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=<host>)(PORT=1521)))(CONNECT_DATA=(SID=<sid>)))",
                "name": "<Name Shown in Sublime>",
                // optional setting: - default is "sqlplus". Path to SQLcl can be specified
                "sql_exec_path": "D:/sqldeveloper/sqlcl/bin/sql.exe",
            },
            {
                "dsn": "USERNAME/PASSWORD@SCHEMANAME2",
                "name": "<Name Shown in Sublime>"
            }
        ]
    }

Some other useful settings

To be able to switch between package spec/header and type spec/body add “pkb”, “pks”, “tpb”, “tps” to the list of extensions.

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