Someone ask me how I work with PL/SQL, here it is...
It was created only for my own usage and tailored for it, so don't ask too much...
-It was only tested on Windows, so it will probably not work out of the box on other OS. But it could probably work.
-The syntax def. come from somewhere on internet and was slightly updated by myself.
-I work with scripts (.sql) that contains more than one 'create or replace' instance.
-It hijack the Build system to modify the output of it. This way standard error navigation (f4/shift+f4) should work.
-It use sqlplus.exe from Oracle (must be on path).
-The menu of Build come from Sublime Text 2\Packages\OracleSQL\oracle_functions.py and have to be updated for your need (a settings will be better, maybe next time ?):
instance_list = "MASTER COMPANY", "DEVELOP/DEVELOP@DEV1252A"], "MASTER PCS", "PCS/PCS@DEV1252A"],
"10.02 COMPANY", "DEMO_MAS_F/DEMO_MAS_F@T1002U"], "10.01 COMPANY", "MAS_F/MAS_F@T4001U"]]
SublimeOracleSQL.zip (12.4 KB)