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.8
  • github.​com
  • 4 months ago
  • 2 hours ago
  • 7 years ago

Installs

  • Total 21K
  • Win 16K
  • Mac 3K
  • Linux 2K
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 Jan 13 Jan 12 Jan 11 Jan 10 Jan 9 Jan 8 Jan 7 Jan 6 Jan 5 Jan 4 Jan 3 Jan 2 Jan 1 Dec 31 Dec 30 Dec 29 Dec 28 Dec 27 Dec 26 Dec 25 Dec 24 Dec 23 Dec 22 Dec 21 Dec 20 Dec 19 Dec 18 Dec 17 Dec 16 Dec 15 Dec 14 Dec 13
Windows 1 3 5 2 3 2 5 4 3 3 1 1 2 0 0 2 2 0 3 0 4 3 2 1 0 0 2 5 0 6 3 0 1 0 0 2 0 3 3 1 1 1 5 3 2 1
Mac 0 0 0 0 0 0 0 0 0 2 0 2 1 1 0 3 2 0 0 2 0 0 0 1 1 1 0 0 0 0 1 1 1 1 0 0 1 0 0 1 1 2 0 1 0 0
Linux 1 1 0 1 0 0 2 0 1 1 0 0 1 0 1 1 0 0 0 0 1 1 0 0 0 0 0 0 0 0 1 0 0 0 0 1 0 0 2 0 0 0 2 0 2 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"]
   } 
}