Thursday, January 26, 2012

PL/SQL Elisp file

The Elisp file for PL/SQL can be found here: http://www.emacswiki.org/emacs/download/plsql.el

I'm trying to byte-compile it as mentioned in the script's comments, but I'm getting this warning: plsql.el:154:1:Warning: defgroup for `plsql' fails to specify containing group.

Not sure if this is a show stopper?

Edit:
changed
(defgroup plsql nil "")
to
(defgroup plsql nil "plsql mode" :group 'SQL)

Reason for this: can't put things into root config in later versions of emacs, so I had to put plsql under the group SQL.

Tuesday, January 10, 2012

Oracle SQL Scripts: optional parameters

I used this technique successfully. Basically if you want &1, &2 (etc.) to be optional and avoid the dreaded forced user interaction if it's not specified: http://eriksekeris.blogspot.com/2010/09/nvl-for-sqlplus-commandline-parameters.html