emacs for rapid prototyping of oracle sql scripts

emacs for rapid prototyping of oracle sql scripts

[Bhagat, Nirav]

Hi,

I believe emacs might be a good editor to use to rapidly prototype Oracle
PL/SQL scripts. My question is if anyone has been in a similar situation as
the one I will describe below, and if emacs was a viable solution. I would
appreciate any responses be directed to myself, but I promise that I will
summarize my learnings to y'all in a later e-mail.

* we keep/run our scripts on our unix servers
* we usually edit scripts on our windows desktops, ftp them over, then run
them for good on the unix box (obviously)
* we usually test out snippets on a flunky windows-based oracle client
(TOAD)..
* will have to jump through hoops to get emacs installed on unix, so will
have to install on windows.
* want a flexible text editor (emacs obviously fits the bill), that can run
snippets of my pl/sql code one at a time..

The grand (well, not really grand, but acceptable) vision would be, emacs
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
them off from within emacs.

I know that, if we were in a perfect world, I'd be doing everything from my
unix box, but for championing emacs, I can't install it on my unix account,
since I can only install stuff on my own windows account.

Any help/thoughts/insight would be greatly appreciated.

Peace,

Nirav
nirav@alumni.rice.edu
 
**************************************************************************
The information transmitted herewith is sensitive information intended only
for use by the individual or entity to which it is addressed. If the reader
of this message is not the intended recipient, you are hereby notified that
any review, retransmission, dissemination, distribution, copying or other
use of, or taking of any action in reliance upon this information is
strictly prohibited. If you have received this communication in error,
please contact the sender and delete the material from your computer.

Re: emacs for rapid prototyping of oracle sql scripts

[Barman Brakjoller]

"Bhagat, Nirav" <nirav.bhagat@capitalone.com> wrote in message 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

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

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

Re: emacs for rapid prototyping of oracle sql scripts

[Galen Boyer]

On Fri, 6 Jun 2003, nirav.bhagat@capitalone.com wrote:

> My question is if anyone has been in a similar situation as the one I
> will describe below, and if emacs was a viable solution. I would
> appreciate any responses be directed to myself, but I promise that I
> will summarize my learnings to y'all in a later e-mail.
> 
> * we keep/run our scripts on our unix servers we usually edit scripts
> * on our windows desktops, ftp them over, then run them for good on
> * the unix box (obviously) we usually test out snippets on a flunky
> * windows-based oracle client (TOAD)..  will have to jump through
> * hoops to get emacs installed on unix, so will have to install on
> * windows.  want a flexible text editor (emacs obviously fits the
> * bill), that can run snippets of my pl/sql code one at a time..

Why not install cygwin on your windows desktop and then write shell
scripts that can run on either machine?

Also, how come you can't access the Oracle instance from your windows
XP client?

-- 
Galen deForest Boyer
Sweet dreams and flying machines in pieces on the ground.

Re: emacs for rapid prototyping of oracle sql scripts

[Tim X]

>>>>> "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!