Home Download Buy Blog Forum Support

Oracle PL/SQL

Oracle PL/SQL

Postby bizoo on Thu Jan 26, 2012 1:26 pm

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...

Notes:
-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 ?):
Code: Select all
class OracleExecuteListCommand(sublime_plugin.WindowCommand):
    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"]]


Good luck.
Attachments
SublimeOracleSQL.zip
(12.43 KiB) Downloaded 846 times
bizoo
 
Posts: 735
Joined: Wed Dec 08, 2010 6:53 am
Location: Switzerland

Re: Oracle PL/SQL

Postby hackvan on Mon Jun 25, 2012 1:48 am

Hi, I'm trying this script with Sublime Text 2 on Ubuntu 12.04 and it's great!!!
thanks a lot.
hackvan
 
Posts: 1
Joined: Mon Jun 25, 2012 1:46 am
Location: Latin America

Re: Oracle PL/SQL

Postby bizoo on Mon Jun 25, 2012 7:52 pm

I am surprised that it works 'out of the box', the binary for sqlplus is called "sqlplus.exe" on Linux too ?
I think I changed a few things in the past months. If I have some times, I will push everything on github.
bizoo
 
Posts: 735
Joined: Wed Dec 08, 2010 6:53 am
Location: Switzerland

Re: Oracle PL/SQL

Postby dudymas on Sat Aug 25, 2012 4:12 pm

Hey, is there a github or bitbucket for this yet?

I'm just mucking around on github and can't find anything there.

If it stays like that, I want to start sharing any changes I make. Would that be okay? I'll just have to link the repo back to this forum post, which is suboptimal.
dudymas
 
Posts: 1
Joined: Sat Aug 25, 2012 4:00 pm

Re: Oracle PL/SQL

Postby bizoo on Mon Aug 27, 2012 6:47 am

dudymas wrote:Hey, is there a github or bitbucket for this yet?

https://github.com/bizoo/Oracle

Feel free to change whatever you want and send Pull request, or Fork it.

As I already wrote in this topic, I only tested it on Windows.
bizoo
 
Posts: 735
Joined: Wed Dec 08, 2010 6:53 am
Location: Switzerland


Return to Plugin Development

Who is online

Users browsing this forum: No registered users and 0 guests