Re: emacs for rapid prototyping of oracle sql scripts

[Tim X <timx@spamto.devnul.com>]

>>>>> "Barman" == Barman Brakjoller <brakjoller@hotmail.com> writes:

 Barman> "Bhagat, Nirav" <nirav.bhagat@capitalone.com> wrote in
 Barman> message
 Barman> news:<mailman.7494.1054925315.21513.help-gnu-emacs@gnu.org>...
 >> Hi,
 >> 
 >> for windows xp, with the capability to run snippets using the
 >> oracle engine that's built in, then ftping them over to the unix
 >> box and (maybe) kicking

 Barman> I wonder what you mean by "the oracle engine that's built
 Barman> in", do you refer to sql-mode, did you think that emacs had
 Barman> some sql-parser inside or is this your dream?

 Barman> Emacs sql-mode + sql*plus client running inside emacs (using
 Barman> the sql-oracle command) + maybe ange-ftp to save your files
 Barman> at the ftp-server in the end should work.

Better, at least for me is

sql-mode
pl/sql mode (see http://www.emacswiki.org)
tramp.

I open a buffer with C-x C-f, which can be either a file on my local
system or one on our unix server where our oracle development
environment is via tramp). I then code away and at times I may mark a
region and send it to oracle via C-c C-r or send the whole buffer with
C-c C-b. I have defined abbrevs for nearly all the sql and plsql
keywords (see abbrev mode) so that I only need to hit a couple of
letters and a space and emacs fills in the rest. I've even got simple
skeletons attached to some of them so that when I type something like
"if" it puts all the bits in, prompts for the condition and then
leaves point between the "then" and "end if" or "else". To further
reduce my typing I use dynamic abbrevs so that I only need to type
long variable names etc once and have emacs fill them in next time. 

All in all, it provides a great environment - I use it daily in my job
(sql and plsql development). 

sorry, never use windows - I do all this via Linux, so I don't know
anything about emacs on XP - however, once you have it running, you
should have access to all of this as most of it is standard emacs -
only tramp and plsql need to be installed in addition to emacs itself
- emacs comes with sql-mode, abbrev and dynamic abbrevs etc.

My boss doesn't mind me doing it this way either as I keep all my code
on the unix server. so, if my desktop linux box crashes and burns
(Yeah, like thats going to happen - has never happened in the nearly
10 years I've been running linux) or if I get hit by a bus (rather
more likely) all the code is on the main development system. Something
which is not the case with the other developers who are using TOAD. 

Tim
Tim
-- 
Tim Cross
The e-mail address on this message is FALSE (obviously!). My real e-mail is
to a company in Australia called rapttech and my login is tcross - if you 
really need to send mail, you should be able to work it out!