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
  • 10 months ago
  • 2 hours ago
  • 8 years ago

Installs

  • Total 22K
  • Win 16K
  • Mac 3K
  • Linux 2K
Aug 2 Aug 1 Jul 31 Jul 30 Jul 29 Jul 28 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
Windows 3 2 1 0 0 3 1 0 0 0 2 3 0 3 0 0 0 4 3 5 3 0 2 0 3 1 2 7 1 1 1 2 4 5 5 5 2 1 4 3 2 2 4 0 3 2
Mac 1 0 0 1 1 0 1 1 0 0 0 3 1 1 1 0 0 0 0 0 1 0 3 0 0 1 0 0 0 0 0 0 1 0 1 0 0 0 2 0 1 0 1 0 0 2
Linux 0 1 2 0 0 1 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 2 1 0 0 1 1 0 0 1 0 0 1 0 1 1 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"]
   } 
}