Advanced PLSQL

by TheEggi ST3

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

Details

Version 0.1.8
Homepage github.com
Modified 4 years ago
Last Seen 2 hours ago
First Seen 11 years ago

Installs

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

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

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