Advanced PLSQL
Advanced Sublime Text package for editing and building Oracle SQL and PL/SQL
Details
Installs
- Total 24K
- Win 18K
- Mac 4K
- Linux 3K
| Mar 31 | Mar 30 | Mar 29 | Mar 28 | Mar 27 | Mar 26 | Mar 25 | Mar 24 | Mar 23 | Mar 22 | Mar 21 | Mar 20 | Mar 19 | Mar 18 | Mar 17 | Mar 16 | Mar 15 | Mar 14 | Mar 13 | Mar 12 | Mar 11 | Mar 10 | Mar 9 | Mar 8 | Mar 7 | Mar 6 | Mar 5 | Mar 4 | Mar 3 | Mar 2 | Mar 1 | Feb 28 | Feb 27 | Feb 26 | Feb 25 | Feb 24 | Feb 23 | Feb 22 | Feb 21 | Feb 20 | Feb 19 | Feb 18 | Feb 17 | Feb 16 | Feb 15 | Feb 14 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Windows | 1 | 2 | 0 | 0 | 0 | 0 | 2 | 2 | 0 | 1 | 1 | 0 | 2 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 2 | 1 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 1 | 1 | 0 | 0 | 1 | 1 |
| Mac | 0 | 0 | 1 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Linux | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 1 | 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"]
}
}