I researched available packages and did find one, but it was more complex than I desired.
When using Sublime to write that code, I wanted an easy way to compile that code into the database. I subscribe to the adage that Application Express code should be in packages and complex queries exposed via Views. Oracle PL SQL Package at Git Hub Building Code Use the menu View -> Syntax -> Open All with Current Extension As... to select the default when you have one of the files open. It is easy enough to default the Syntax for the file type using built in Sublime Text features. This allows for easier to read code and syntax identification.įor our projects, we use the extensions of. The Oracle PL SQL extension provides the addition of PL/SQL syntax highlighting in Sublime Text beyond the standard included SQL highlighter. To use Abacus, you select the lines you would like to align using your mouse or keyboard, then select abacus from the Selection menu or use the shortcut key assigned.īefore Abacus Alignment After Alignment Before Alignment After Alignment Now when using Abacus, it will align the :=, =>, OUT, IN and || tokens in a line. Instead, do a “save as” into the “User Directory” with the same file name.Īdd additional “token” values to the USER settings for Abacus. Navigate to Preferences -> Package Settings -> Abacus -> Settings – DefaultĪs a good practice, don’t change the default settings file. The issue for oracle developers is that the := and the => are not supported by default. Some of my favorite tutorial and document sites:Ībacus is useful for aligning multiple values that follow a similar syntax such as a := ‘value’ These two extension packages are what I like to use most to complement the built in functionality of Sublime Text to develop Oracle packages.
The folks at Wbond have a package manager that makes extensions very simple.Īfter the Package Control is installed, open the use Package Control Command List and install the following packages: One of the exciting parts of Sublime Text is not just the multi cursors, but the ability for people to Extend the platform. (I am a licensed user to support their good work)
To the best of my knowledge the trial does not expire, but I like the idea of being able to exercise the software fully before purchasing.
Sublime Text is a commercial software that has a fully functional trial. My intention not to re-do Sublime documentation or duplicate what others have already done, but to show you what has worked for me. This is especially true with Sublime Text. As with many things, there is more than one way to accomplish a goal. Regardless, the concepts apply to Linux, Mac or Windows. The pictures may have steps or details specific to one OS or the other. As it is cross platform, I use it on MAC, Windows, and Linux operating system (often simultaneously).
I use Sublime Text every day and have found it to be a great productivity tool. Well, actually it is more for any PL/SQL development, but it just sounds cooler. The following is information related to using Sublime Text for developing Oracle APEX Applications.