From mboxrd@z Thu Jan 1 00:00:00 1970 Path: main.gmane.org!not-for-mail From: Tim X Newsgroups: gmane.emacs.help Subject: Re: emacs for rapid prototyping of oracle sql scripts Date: 08 Jun 2003 23:22:59 +1000 Sender: help-gnu-emacs-bounces+gnu-help-gnu-emacs=m.gmane.org@gnu.org Message-ID: <87y90cbt58.fsf@tiger.rapttech.com.au> References: <1c58a7c3.0306061408.64364a5f@posting.google.com> Reply-To: timx@spamto.devnul.com NNTP-Posting-Host: main.gmane.org Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Trace: main.gmane.org 1055077936 1026 80.91.224.249 (8 Jun 2003 13:12:16 GMT) X-Complaints-To: usenet@main.gmane.org NNTP-Posting-Date: Sun, 8 Jun 2003 13:12:16 +0000 (UTC) Original-X-From: help-gnu-emacs-bounces+gnu-help-gnu-emacs=m.gmane.org@gnu.org Sun Jun 08 15:12:15 2003 Return-path: Original-Received: from monty-python.gnu.org ([199.232.76.173]) by main.gmane.org with esmtp (Exim 3.35 #1 (Debian)) id 19Ozy3-0000GQ-00 for ; Sun, 08 Jun 2003 15:12:15 +0200 Original-Received: from localhost ([127.0.0.1] helo=monty-python.gnu.org) by monty-python.gnu.org with esmtp (Exim 4.20) id 19OzwR-00042O-6w for gnu-help-gnu-emacs@m.gmane.org; Sun, 08 Jun 2003 09:10:35 -0400 Original-Newsgroups: gnu.emacs.help Original-Lines: 61 User-Agent: Gnus/5.09 (Gnus v5.9.0) Emacs/21.3 Original-NNTP-Posting-Host: ppp665.nsw.padsl.internode.on.net Original-X-Trace: duster.adelaide.on.net 1055077763 ppp665.nsw.padsl.internode.on.net (8 Jun 2003 22:39:23 +0950) Original-Path: shelby.stanford.edu!newsfeed.stanford.edu!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!news1.optus.net.au!optus!news.mel.connect.com.au!news.ade.connect.com.au!duster.adelaide.on.net!not-for-mail Original-Xref: shelby.stanford.edu gnu.emacs.help:114288 Original-To: help-gnu-emacs@gnu.org X-BeenThere: help-gnu-emacs@gnu.org X-Mailman-Version: 2.1b5 Precedence: list List-Id: Users list for the GNU Emacs text editor List-Help: List-Post: List-Subscribe: , List-Archive: List-Unsubscribe: , Errors-To: help-gnu-emacs-bounces+gnu-help-gnu-emacs=m.gmane.org@gnu.org Xref: main.gmane.org gmane.emacs.help:10782 X-Report-Spam: http://spam.gmane.org/gmane.emacs.help:10782 >>>>> "Barman" == Barman Brakjoller writes: Barman> "Bhagat, Nirav" wrote in Barman> message Barman> news:... >> 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!