| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Emacs on SQLPlus, er uh... SQLPlus on emacs.
I know what you mean. The best I can come up with is
http://www.emacswiki.org/cgi-bin/wiki.pl?SqlMode. My .emacs has been built
up over five years. Its not pretty, but I'd be lost without it.
Fortunately, sql-mode comes with GNU emacs (and I'm almost certain, with Xemacs) and doesn't need any setup beyond ensuring that Emacs can find the oracle client installation. Simply type M-x sql-oracle. It will prompt for the username, password and sqlnet alias and then try to log you in.
Regards
David Lord
> -----Original Message-----
> From: Lee Cullip [mailto:Lee.Cullip_at_three.co.uk]
> Sent: 28 July 2003 13:49
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Emacs on SQLPlus, er uh... SQLPlus on emacs.
>
>
> I'd see myself as one of the old dinosaur type's!! (Been
> using vi since I
> can remember) ;-) I've tried playing with emacs many times,
> but it's the
> configuration that put's me off everytime. Is there a good source of
> information for configuring emacs with sql support ?
>
> Regards
> Lee
>
> -----Original Message-----
> Sent: 28 July 2003 13:21
> To: Multiple recipients of list ORACLE-L
>
>
> I use sql-mode for local databases. Its got the advantage
> that you can
> 'pop' sql statements from another buffer into it, giving you
> something very
> like the sqlplus worksheet. Its great when you're fiddling with a big
> query.
>
> Also, I use emacs with the vi emulation (viper) so I get the
> best of both
> worlds;)
>
> Regards
> David Lord
>
> > -----Original Message-----
> > From: Jeremiah Wilton [mailto:jwilton_at_speakeasy.net]
> > Sent: 26 July 2003 10:09
> > To: Multiple recipients of list ORACLE-L
> > Subject: RE: Emacs on SQLPlus, er uh... SQLPlus on emacs.
> >
> >
> > I use SQL*Plus running under emacs shell every day. It is my
> > preferred way of:
> >
> > - Recording my sqlplus sessions so I can go back and search to see
> > what I did
> > - having an up-arrow comand history capability
> > - Having line editing capability
> > - editing SQL scripts in the same window where I am running
> > - everything else
> >
> > I came to prefer emacs because it has capabilities far in
> excess of vi
> > or any other unix editor. Because it is open source software, many
> > people have contributed over the years, making the package extremely
> > powerful. Also, I started on Vax/VMS edt and eve/tpu,
> which are more
> > like emacs than vi.
> >
> > There is an emacs OracleSQL mode, but I don't use it. I just start
> > emacs, META-X shell, then sqlplus...
> >
> > --
> > Jeremiah Wilton
> > http://www.speakeasy.net/~jwilton
> >
> > On Fri, 25 Jul 2003, Orr, Steve wrote:
> >
> > > I agree with the developer vs. sysadmin generalization but
> > this was not
> > > meant to be a post about favorite editors... It's about
> > whether anyone
> > > has used or seen a SQLPlus "shell" running under emacs. Has anyone
> > > "witnessed" SQLPlus running under a well-configured emacs
> > session and
> > > have impressions to share?
> > >
> > > The statistics I've heard are that 9 out of 10
> > SysAdmin/DBA's use vi. I
> > > wonder what the breakdown is for Linux admins? Since emacs
> > is easy to
> > > implement I could see it gaining ground on Linux but sometimes old
> > > dinosaur type SysAdmins are slow to evolve. :-)
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > --
> > Author: Jeremiah Wilton
> > INET: jwilton_at_speakeasy.net
> >
> > Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> > San Diego, California -- Mailing list and web
> hosting services
> >
> ---------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from). You may
> > also send the HELP command for other information (like subscribing).
> >
>
>
> **********************************************************************
> This communication is intended for the addressee(s) named
> above only. This
> communication may contain confidential or privileged
> information. If you
> are not the intended recipient, please do not read, copy, use
> or disclose
> this communication to others; also please notify the sender
> by replying to
> the email communication or by telephone and then delete the
> communication
> and any copies of it.
> Viruses: Although we have taken steps to ensure that this e-mail and
> attachments are free from any virus, we advise that in
> keeping with good
> computing practice the recipient should ensure that they are
> actually virus
> free.
> **********************************************************************
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Lord David
> INET: David.Lord_at_hays-ims.com
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
>
> ______________________________________________________________
> __________
>
> This e-mail message (including any attachment) is intended
> only for the personal
> use of the recipient(s) named above. This message is
> confidential and may be
> legally privileged. If you are not an intended recipient,
> you may not review, copy or
> distribute this message. If you have received this
> communication in error, please notify
> us immediately by e-mail and delete the original message.
>
> Any views or opinions expressed in this message are those of
> the author only.
> Furthermore, this message (including any attachment) does not
> create any legally
> binding rights or obligations whatsoever, which may only be
> created by the exchange
> of hard copy documents signed by a duly authorised
> representative of Hutchison
> 3G UK Limited.
> ______________________________________________________________
> __________
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Lee Cullip
> INET: Lee.Cullip_at_three.co.uk
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Lord David INET: David.Lord_at_hays-ims.com Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).Received on Mon Jul 28 2003 - 08:14:24 CDT
 |
 |