RE: Emacs on SQLPlus, er uh... SQLPlus on emacs.
Howdy Jeremiah, Based on your "testimonial" I have given this a try and am beginning to see the coolness of it all. Regarding... > There is an emacs OracleSQL mode, but I don't use it. I just start emacs, > META-X shell, then sqlplus... I've tried both. Any particular reason for using or not using OracleSQL mode? I've only one complaint, (so far :), the output of SQL statement result sets is slower than just straight SQLPlus. Any way to speed this up? Any way to interrupt the output? AtDhVaAnNkCsE, Steve Orr Bozeman, Montana -Original Message- Sent: Saturday, July 26, 2003 3:09 AM To: Multiple recipients of list ORACLE-L 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: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Orr, Steve INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: Emacs on SQLPlus, er uh... SQLPlus on emacs.
What's more, it's very cheap for the quality and features...:-) In article <[EMAIL PROTECTED]>, Grant Allen <[EMAIL PROTECTED]> writes >> Hi >> >> I use vi on Unix and textpad on windoze. I like to write macros for vi >> so it types repetitive code for me...:-), although I should >> probably use >> an editor with more powerful macro facilities. >> >> cheers >> >> Pete > >Pete! Another textpad fan ... way to go! An outstanding text editor for >windows (even better than ultraedit in my opinion) > >Ciao >Fuzzy >:-) > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Pete Finnigan email:[EMAIL PROTECTED] Web site: http://www.petefinnigan.com - Oracle security audit specialists Book:Oracle security step-by-step Guide - see http://store.sans.org for details. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pete Finnigan INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: Emacs on SQLPlus, er uh... SQLPlus on emacs.
> LOL--I'm the sole ultraedit fan in a den of textpad users & have had > many conversations that start with the phrase "yeah, but can > your editor > do this...". > > I was of the opinion that they were pretty much equal until someone > (Dennis Williams?) wrote in reminding me of ue's ability to > open/edit/save a file on a remote host via ftp. It appears > that tp does > that only w/a supporting batch file (yuck!). > > Imagine my delighted cackling, having proven once and for all > that ue is > the one true windows text editor... 8^) It's never been an issue for me ... tightVNC being the wonderful beast it is, I've gotten used to in-place editing through a vnc session. Big benefit being that a dropped session can be picked up again ... not easy if your FTP transfer fails :-). That said, I can see the benefits of bringing the mountain to you :-) Ciao Fuzzy :-) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Grant Allen INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: Emacs on SQLPlus, er uh... SQLPlus on emacs.
LOL--I'm the sole ultraedit fan in a den of textpad users & have had many conversations that start with the phrase "yeah, but can your editor do this...". I was of the opinion that they were pretty much equal until someone (Dennis Williams?) wrote in reminding me of ue's ability to open/edit/save a file on a remote host via ftp. It appears that tp does that only w/a supporting batch file (yuck!). Imagine my delighted cackling, having proven once and for all that ue is the one true windows text editor... 8^) -Roy Roy Pardee Programmer/Analyst/DBA SWFPAC Lockheed Martin IT Extension 8487 -Original Message- Sent: Tuesday, July 29, 2003 9:44 AM To: Multiple recipients of list ORACLE-L > Hi > > I use vi on Unix and textpad on windoze. I like to write macros for vi > so it types repetitive code for me...:-), although I should > probably use > an editor with more powerful macro facilities. > > cheers > > Pete Pete! Another textpad fan ... way to go! An outstanding text editor for windows (even better than ultraedit in my opinion) Ciao Fuzzy :-) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Grant Allen INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: Pardee, Roy E INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: Emacs on SQLPlus, er uh... SQLPlus on emacs.
Or, for you GPL, cross-platform fans, there's NEdit at http://www.nedit.org I've made a simple addition to it's extensible config file so that it properly highlights all available Oracle 8i parameters when editing an init.ora file. My v5.3 .nedit file can be nabbed from http://society.servebeer.com/.nedit Look for the "Oracle" highlight in the file. Any additions/corrections are more than welcome. Enjoy! Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA > -Original Message- > From: Grant Allen [mailto:[EMAIL PROTECTED] > Sent: Tuesday, July 29, 2003 11:44 AM > To: Multiple recipients of list ORACLE-L > Subject: RE: Emacs on SQLPlus, er uh... SQLPlus on emacs. > > > > Hi > > > > I use vi on Unix and textpad on windoze. I like to write > macros for vi > > so it types repetitive code for me...:-), although I should > > probably use > > an editor with more powerful macro facilities. > > > > cheers > > > > Pete > > Pete! Another textpad fan ... way to go! An outstanding text > editor for > windows (even better than ultraedit in my opinion) > > Ciao > Fuzzy > :-) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: Emacs on SQLPlus, er uh... SQLPlus on emacs.
> Hi > > I use vi on Unix and textpad on windoze. I like to write macros for vi > so it types repetitive code for me...:-), although I should > probably use > an editor with more powerful macro facilities. > > cheers > > Pete Pete! Another textpad fan ... way to go! An outstanding text editor for windows (even better than ultraedit in my opinion) Ciao Fuzzy :-) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Grant Allen INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: Emacs on SQLPlus, er uh... SQLPlus on emacs.
Thanks for this David, it's given me somewhere to start!!!
Cheers
Lee
-Original Message-
Sent: 28 July 2003 17:35
To: Multiple recipients of list ORACLE-L
Here's mine with references to optional packages (mainly jde) removed. Its
set up for windows and cygwin, so if you're using something else (better;)
you can remove the cygwin bit at the end.
--x--x--x--x--x--cut-here--x--x--x--x--x--
(setq viper-mode t)
(require 'viper)
(custom-set-variables
;; custom-set-variables was added by Custom -- don't edit or cut/paste it!
;; Your init file should contain only one such instance.
'(auto-compression-mode t nil (jka-compr))
'(case-fold-search t)
'(column-number-mode t)
'(current-language-environment "Latin-1")
'(default-input-method "latin-1-prefix")
'(fill-column 80)
'(font-lock-maximum-size 1048576)
'(frame-background-mode (quote dark))
'(global-font-lock-mode t nil (font-lock))
'(indent-tabs-mode nil)
'(mouse-wheel-mode t nil (mwheel))
'(perl-continued-brace-offset -3)
'(perl-continued-statement-offset 3)
'(perl-indent-level 3)
'(sgml-indent-data t t)
'(tab-width 3)
'(text-mode-hook (quote (turn-on-auto-fill (lambda nil (auto-fill-mode 1))
viper-mode text-mode-hook-identify)))
'(viper-auto-indent t)
'(viper-electric-mode nil)
'(viper-emacs-state-mode-list (quote (custom-mode dired-mode efs-mode
tar-mode mh-folder-mode gnus-group-mode gnus-summary-mode Info-mode
Buffer-menu-mode view-mode vm-mode vm-summary-mode SQLi-mode
sql-interactive-mode shell-mode csh-mode ksh-mode comint-mode telnet-mode
rlogin-mode)))
'(viper-vi-state-mode-list (quote (fundamental-mode makefile-mode help-mode
awk-mode m4-mode html-mode emacs-lisp-mode lisp-mode lisp-interaction-mode
java-mode cc-mode c-mode c++-mode fortran-mode f90-mode basic-mode bat-mode
asm-mode prolog-mode text-mode indented-text-mode tex-mode latex-mode
bibtex-mode completion-list-mode compilation-mode perl-mode javascript-mode
tcl-mode python-mode gnus-article-mode mh-show-mode sql-mode sh-mode
Man-mode man-mode
;; SQL/PL/SQL mode
(add-to-list 'auto-mode-alist '("\\.sql$" . sql-mode))
(add-to-list 'auto-mode-alist '("\\.pls$" . sql-mode))
(add-to-list 'auto-mode-alist '("\\.plb$" . sql-mode))
(eval-after-load "sql"
'(font-lock-add-keywords
'sql-mode
'(("\\<\\(exception\\|notfound\\|pragma\\|cursor_already_open\\|dup_val_on_i
ndex\\|invalid_cursor\\|invalid_number\\|login_denied\\|no_data_found\\|not_
logged_on\\|program_error\\|storage_error\\|timeout_on_resource\\|too_many_r
ows\\|transaction_backed_out\\|value_error\\|zero_divide\\|others\\)\\>" .
font-lock-warning-face)
("\\" . font-lock-keyword-face)
("\\<\\(if\\|elsif\\|else\\|while\\|return\\)\\>" .
font-lock-function-name-face
(autoload 'sql-oracle "sql" "Interactive SQL mode." t):w
;; Load dired-x
(require 'dired-x)
;; Another attept to get cygwin working
(setq binary-process-input t)
(setq w32-quote-process-args ?\")
(setq shell-file-name "bash") ;; or sh if you rename your bash executable to
sh.
(setenv "SHELL" shell-file-name)
(setq explicit-shell-file-name shell-file-name)
(setq explicit-sh-args '("-login" "-i"))
--x--x--x--x--x--cut-here--x--x--x--x--x--
> -Original Message-
> From: Lee Cullip [mailto:[EMAIL PROTECTED]
> Sent: 28 July 2003 16:24
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Emacs on SQLPlus, er uh... SQLPlus on emacs.
>
>
> Thanks David, that is pretty good stuff. Where would the
> .emacs file be for
> this so that I can have a look and try and understand the
> configuration?
>
> Cheers
> Lee
>
> -Original Message-
> Sent: 28 July 2003 14:14
> To: Multiple recipients of list ORACLE-L
>
>
> 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:[EMAIL PROTECTED]
> > Sent: 28 July 2003 13:49
> > To: Multiple recipients of list ORACLE-L
> > Subject: RE: Emacs on SQLPlus, er uh... SQLPlus on emacs.
> >
> >
> > I&
RE: Emacs on SQLPlus, er uh... SQLPlus on emacs.
Ok, I like vi, that's why I turn on vi emulation in emacs. I use vim for quick file viewing because it loads faster than emacs. But, over time, I've found that emacs gives you a load of little extras that suck you in and become indispensible. A few that spring to mind: - - jde - java IDE, does most things that eclipse will without the memory footprint and crashes. - dired - directory browsing including remote browsing via ftp - sql-mode - sqlplus in emacs - gnuserve - so you can open up files from windows explorer in a pre-existing emacs instance. Yeah, you can probably get all of these from other programs that you use in conjunction with vim, but you don't get the integration (plus vim's syntax highlighting is slow. I've got a 200k perl script that takes minutes to highlight in vim, but only a few seconds in emacs). What have you got to lose (apart from a few months of your life messing with your .emacs). YMMV David Lord > -Original Message- > From: Stefan Jahnke [mailto:[EMAIL PROTECTED] > Sent: 28 July 2003 14:49 > To: Multiple recipients of list ORACLE-L > Subject: AW: Emacs on SQLPlus, er uh... SQLPlus on emacs. > > > vi on *nix and cygwin is the friend > > Stefan Jahnke > Consultant > BOV Aktiengesellschaft > Tel.: +49 201/45 13-289 > mailto:[EMAIL PROTECTED] > http://www.bov.de > Abonnieren Sie unseren Newsletter: http://www.bov.de/enews > > Kosten senken - strategische IT-Ziele erreichen! BOV Microsoft Day am > 24.07.03 in Essen. Anmeldung unter > http://www.bov.de/microsoft-day oder > mailto:[EMAIL PROTECTED] > > Wie Sie wissen, koennen ueber das Internet versandte E-Mails > leicht unter > fremden Namen erstellt oder manipuliert werden. Aus diesem > Grunde bitten wir > um Verstaendnis dafuer, dass wir zu Ihrem und unserem Schutz > die rechtliche > Verbindlichkeit der vorstehenden Erklaerungen und Aeusserungen > ausschliessen. > > As you are probably aware, e-mails sent via the Internet can easily be > copied or manipulated by third parties. For this reason we > would ask for > your understanding that, for your own protection and ours, we > must decline > all legal responsibility for the validity of the statements > and comments > given above. > > > -Ursprüngliche Nachricht- > Von: Orr, Steve [mailto:[EMAIL PROTECTED] > Gesendet: Freitag, 25. Juli 2003 22:10 > An: Multiple recipients of list ORACLE-L > Betreff: Emacs on SQLPlus, er uh... SQLPlus on emacs. > > > vi is what I use and it's the predominant editor for > SysAdmin/DBA types > but I'm curious as to how many DBA's use emacs. I just saw a demo of > SQL*Plus running under emacs and it was quite functional... Sorta like > and IDE for SQL without Windoze GUI dependencies. Any DBA's > use emacs on > a daily basis? > > :wq (Or ZZ) > Steve Orr > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Orr, Steve > INET: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: Stefan Jahnke > INET: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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
RE: Emacs on SQLPlus, er uh... SQLPlus on emacs.
Here's mine with references to optional packages (mainly jde) removed. Its
set up for windows and cygwin, so if you're using something else (better;)
you can remove the cygwin bit at the end.
--x--x--x--x--x--cut-here--x--x--x--x--x--
(setq viper-mode t)
(require 'viper)
(custom-set-variables
;; custom-set-variables was added by Custom -- don't edit or cut/paste it!
;; Your init file should contain only one such instance.
'(auto-compression-mode t nil (jka-compr))
'(case-fold-search t)
'(column-number-mode t)
'(current-language-environment "Latin-1")
'(default-input-method "latin-1-prefix")
'(fill-column 80)
'(font-lock-maximum-size 1048576)
'(frame-background-mode (quote dark))
'(global-font-lock-mode t nil (font-lock))
'(indent-tabs-mode nil)
'(mouse-wheel-mode t nil (mwheel))
'(perl-continued-brace-offset -3)
'(perl-continued-statement-offset 3)
'(perl-indent-level 3)
'(sgml-indent-data t t)
'(tab-width 3)
'(text-mode-hook (quote (turn-on-auto-fill (lambda nil (auto-fill-mode 1))
viper-mode text-mode-hook-identify)))
'(viper-auto-indent t)
'(viper-electric-mode nil)
'(viper-emacs-state-mode-list (quote (custom-mode dired-mode efs-mode
tar-mode mh-folder-mode gnus-group-mode gnus-summary-mode Info-mode
Buffer-menu-mode view-mode vm-mode vm-summary-mode SQLi-mode
sql-interactive-mode shell-mode csh-mode ksh-mode comint-mode telnet-mode
rlogin-mode)))
'(viper-vi-state-mode-list (quote (fundamental-mode makefile-mode help-mode
awk-mode m4-mode html-mode emacs-lisp-mode lisp-mode lisp-interaction-mode
java-mode cc-mode c-mode c++-mode fortran-mode f90-mode basic-mode bat-mode
asm-mode prolog-mode text-mode indented-text-mode tex-mode latex-mode
bibtex-mode completion-list-mode compilation-mode perl-mode javascript-mode
tcl-mode python-mode gnus-article-mode mh-show-mode sql-mode sh-mode
Man-mode man-mode
;; SQL/PL/SQL mode
(add-to-list 'auto-mode-alist '("\\.sql$" . sql-mode))
(add-to-list 'auto-mode-alist '("\\.pls$" . sql-mode))
(add-to-list 'auto-mode-alist '("\\.plb$" . sql-mode))
(eval-after-load "sql"
'(font-lock-add-keywords
'sql-mode
'(("\\<\\(exception\\|notfound\\|pragma\\|cursor_already_open\\|dup_val_on_i
ndex\\|invalid_cursor\\|invalid_number\\|login_denied\\|no_data_found\\|not_
logged_on\\|program_error\\|storage_error\\|timeout_on_resource\\|too_many_r
ows\\|transaction_backed_out\\|value_error\\|zero_divide\\|others\\)\\>" .
font-lock-warning-face)
("\\" . font-lock-keyword-face)
("\\<\\(if\\|elsif\\|else\\|while\\|return\\)\\>" .
font-lock-function-name-face
(autoload 'sql-oracle "sql" "Interactive SQL mode." t):w
;; Load dired-x
(require 'dired-x)
;; Another attept to get cygwin working
(setq binary-process-input t)
(setq w32-quote-process-args ?\")
(setq shell-file-name "bash") ;; or sh if you rename your bash executable to
sh.
(setenv "SHELL" shell-file-name)
(setq explicit-shell-file-name shell-file-name)
(setq explicit-sh-args '("-login" "-i"))
--x--x--x--x--x--cut-here--x--x--x--x--x--
> -Original Message-
> From: Lee Cullip [mailto:[EMAIL PROTECTED]
> Sent: 28 July 2003 16:24
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Emacs on SQLPlus, er uh... SQLPlus on emacs.
>
>
> Thanks David, that is pretty good stuff. Where would the
> .emacs file be for
> this so that I can have a look and try and understand the
> configuration?
>
> Cheers
> Lee
>
> -Original Message-
> Sent: 28 July 2003 14:14
> To: Multiple recipients of list ORACLE-L
>
>
> 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:[EMAIL PROTECTED]
> > 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,
> >
RE: Emacs on SQLPlus, er uh... SQLPlus on emacs.
Thanks David, that is pretty good stuff. Where would the .emacs file be for this so that I can have a look and try and understand the configuration? Cheers Lee -Original Message- Sent: 28 July 2003 14:14 To: Multiple recipients of list ORACLE-L 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:[EMAIL PROTECTED] > 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:[EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] > > > > 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: [EMAIL PROTECTED] (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). > > > > > ***
Re: Emacs on SQLPlus, er uh... SQLPlus on emacs.
Coolness. Thanks David. I fired up Xemacs and, following your instructions, was able to log into one of my databases. Now I have a 'cool toy' to play with! Dwayne Lord David wrote: 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 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Dwayne Cox INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
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:[EMAIL PROTECTED] > 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:[EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] > > > > 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: [EMAIL PROTECTED] (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 >
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:[EMAIL PROTECTED] > 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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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
RE: Emacs on SQLPlus, er uh... SQLPlus on emacs.
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:[EMAIL PROTECTED] > 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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: Emacs on SQLPlus, er uh... SQLPlus on emacs.
Cool, but it also begs the question as to why SQL*Plus doesn't have line editing capability? Even in 9i, unless I don't know the keystrokes to do the line editing ... v/r Stephen S. Wolfe, GS-11, DAFC Data Services Manager [EMAIL PROTECTED] (813) 827-9974 DSN 651-9974 > -Original Message- > From: Jeremiah Wilton [mailto:[EMAIL PROTECTED] > Sent: Saturday, July 26, 2003 5:09 AM > 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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: Wolfe Stephen S GS-11 6 MDSS/SGSI INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: Emacs on SQLPlus, er uh... SQLPlus on emacs.
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. :-) Steve Orr-asaurus, with apologies to Don G. -Original Message- Sent: Friday, July 25, 2003 2:24 PM To: Multiple recipients of list ORACLE-L It seems like DBAs that use Emacs over vi (emacs vs. vi being the classic UNIX holy war) tend to be people who were introduced to UNIX by being either a developer or an end-user. If a DBA favors vi over emacs, it seems that they generally come from a sysadmin background. That's how I ended up a vi user - none of the systems I was ever working on could be counted to have any editor OTHER than vi. For better or worse, its the ubiquitous UNIX text editor. Of course, there are those who use notepad + ftp Matt -- Matthew Zito GridApp Systems Email: [EMAIL PROTECTED] Cell: 646-220-3551 Phone: 212-358-8211 x 359 http://www.gridapp.com > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf > Of Orr, Steve > Sent: Friday, July 25, 2003 3:10 PM > To: Multiple recipients of list ORACLE-L > Subject: Emacs on SQLPlus, er uh... SQLPlus on emacs. > > > vi is what I use and it's the predominant editor for SysAdmin/DBA > types but I'm curious as to how many DBA's use emacs. I just saw a > demo of SQL*Plus running under emacs and it was quite functional... > Sorta like and IDE for SQL without Windoze GUI dependencies. Any DBA's > use emacs on a daily basis? > > :wq (Or ZZ) > Steve Orr -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Orr, Steve INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: Emacs on SQLPlus, er uh... SQLPlus on emacs.
Our servers (AIX/HP) don't even have emacs on it. Use vi for small stuff otherwise I fall into the ftp with windows environment to work. I use CodeWright. From: "Orr, Steve" <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Subject: Emacs on SQLPlus, er uh... SQLPlus on emacs. Date: Fri, 25 Jul 2003 12:09:36 -0800 vi is what I use and it's the predominant editor for SysAdmin/DBA types but I'm curious as to how many DBA's use emacs. I just saw a demo of SQL*Plus running under emacs and it was quite functional... Sorta like and IDE for SQL without Windoze GUI dependencies. Any DBA's use emacs on a daily basis? :wq (Or ZZ) Steve Orr -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Orr, Steve INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). _ Add photos to your e-mail with MSN 8. Get 2 months FREE*. http://join.msn.com/?page=features/featuredemail -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: david davis INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: Emacs on SQLPlus, er uh... SQLPlus on emacs.
I use MicroEMACS almost every day, albeit on my Amiga (or now on my UAE Amiga emulator) to edit webpages and not really for DBA work. Hey, us obnoxious Amigans have to get in every plug we can! :) Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA > -Original Message- > From: Orr, Steve [mailto:[EMAIL PROTECTED] > Sent: Friday, July 25, 2003 3:10 PM > To: Multiple recipients of list ORACLE-L > Subject: Emacs on SQLPlus, er uh... SQLPlus on emacs. > > > vi is what I use and it's the predominant editor for > SysAdmin/DBA types > but I'm curious as to how many DBA's use emacs. I just saw a demo of > SQL*Plus running under emacs and it was quite functional... Sorta like > and IDE for SQL without Windoze GUI dependencies. Any DBA's > use emacs on > a daily basis? > > :wq (Or ZZ) > Steve Orr -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: Emacs on SQLPlus, er uh... SQLPlus on emacs.
Steve - I've used Unix for many years at many different sites, mostly with large development staffs. In that time, I've only encountered one emacs user. He said that emacs had many capabilities, but they struggled several months getting it even semi-functional. I'm not sure they had it working when I left, at least he was too frustrated to gloat. Mostly I've seen people use something better than vi. If your site uses a GUI interface like X-Windows, then there will be a GUI editor. Currently people that wish to avoid vi tend to copy and paste over to Notepad. On my first Unix assignment I was doing documentation. So I decided to write documents on vi. Turns out vi has some great word processing features, like word wrap. Anyway I used that assignment to learn vi really well and that has paid off really well over the years. As I said, every site has had something better than vi, but that something has always been different and vi never changes. Why tamper with perfection? ;-) Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, July 25, 2003 3:10 PM To: Multiple recipients of list ORACLE-L vi is what I use and it's the predominant editor for SysAdmin/DBA types but I'm curious as to how many DBA's use emacs. I just saw a demo of SQL*Plus running under emacs and it was quite functional... Sorta like and IDE for SQL without Windoze GUI dependencies. Any DBA's use emacs on a daily basis? :wq (Or ZZ) Steve Orr -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Orr, Steve INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: DENNIS WILLIAMS INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: Emacs on SQLPlus, er uh... SQLPlus on emacs.
Title: RE: Emacs on SQLPlus, er uh... SQLPlus on emacs. vi for unix ... vim for windows Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message- From: Dwayne Cox [mailto:[EMAIL PROTECTED]] Sent: Friday, July 25, 2003 5:39 PM To: Multiple recipients of list ORACLE-L Subject: Re: Emacs on SQLPlus, er uh... SQLPlus on emacs. For Windows work, I love UltraEdit. For *nix work, vi(m)'s the ticket. -- Dwayne Cox Corporate Database Administrator Info Tech, Inc. 5700 SW 34th Street, Suite 1235 Gainesville, FL 32608 email: [EMAIL PROTECTED] phone: 352.381.4521 fax: 352.381. Goulet, Dick wrote: > My editor of choice is UltraEdit-32 from IDM, especially since the intergrated FTP into the editor. > > Dick Goulet > Senior Oracle DBA > Oracle Certified 8i DBA > > -Original Message- > Sent: Friday, July 25, 2003 4:24 PM > To: Multiple recipients of list ORACLE-L > > > > > > It seems like DBAs that use Emacs over vi (emacs vs. vi being the > classic UNIX holy war) tend to be people who were introduced to UNIX by > being either a developer or an end-user. If a DBA favors vi over emacs, > it seems that they generally come from a sysadmin background. That's > how I ended up a vi user - none of the systems I was ever working on > could be counted to have any editor OTHER than vi. For better or worse, > its the ubiquitous UNIX text editor. > > > > Of course, there are those who use notepad + ftp > > Matt > > -- > Matthew Zito > GridApp Systems > Email: [EMAIL PROTECTED] > Cell: 646-220-3551 > Phone: 212-358-8211 x 359 > http://www.gridapp.com > > >>-Original Message- >>From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On >>Behalf Of Orr, Steve >>Sent: Friday, July 25, 2003 3:10 PM >>To: Multiple recipients of list ORACLE-L >>Subject: Emacs on SQLPlus, er uh... SQLPlus on emacs. >> >> >>vi is what I use and it's the predominant editor for >>SysAdmin/DBA types but I'm curious as to how many DBA's use >>emacs. I just saw a demo of SQL*Plus running under emacs and >>it was quite functional... Sorta like and IDE for SQL without >>Windoze GUI dependencies. Any DBA's use emacs on a daily basis? >> >>:wq (Or ZZ) >>Steve Orr >>-- >>Please see the official ORACLE-L FAQ: http://www.orafaq.net >>-- >>Author: Orr, Steve >> INET: [EMAIL PROTECTED] >> >>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: [EMAIL PROTECTED] (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). >> > > -- Dwayne Cox Corporate Database Administrator Info Tech, Inc. 5700 SW 34th Street, Suite 1235 Gainesville, FL 32608 email: [EMAIL PROTECTED] phone: 352.381.4521 fax: 352.381. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Dwayne Cox INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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 is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*2
Re: Emacs on SQLPlus, er uh... SQLPlus on emacs.
For Windows work, I love UltraEdit. For *nix work, vi(m)'s the ticket. -- Dwayne Cox Corporate Database Administrator Info Tech, Inc. 5700 SW 34th Street, Suite 1235 Gainesville, FL 32608 email: [EMAIL PROTECTED] phone: 352.381.4521 fax: 352.381. Goulet, Dick wrote: My editor of choice is UltraEdit-32 from IDM, especially since the intergrated FTP into the editor. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Friday, July 25, 2003 4:24 PM To: Multiple recipients of list ORACLE-L It seems like DBAs that use Emacs over vi (emacs vs. vi being the classic UNIX holy war) tend to be people who were introduced to UNIX by being either a developer or an end-user. If a DBA favors vi over emacs, it seems that they generally come from a sysadmin background. That's how I ended up a vi user - none of the systems I was ever working on could be counted to have any editor OTHER than vi. For better or worse, its the ubiquitous UNIX text editor. Of course, there are those who use notepad + ftp Matt -- Matthew Zito GridApp Systems Email: [EMAIL PROTECTED] Cell: 646-220-3551 Phone: 212-358-8211 x 359 http://www.gridapp.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Orr, Steve Sent: Friday, July 25, 2003 3:10 PM To: Multiple recipients of list ORACLE-L Subject: Emacs on SQLPlus, er uh... SQLPlus on emacs. vi is what I use and it's the predominant editor for SysAdmin/DBA types but I'm curious as to how many DBA's use emacs. I just saw a demo of SQL*Plus running under emacs and it was quite functional... Sorta like and IDE for SQL without Windoze GUI dependencies. Any DBA's use emacs on a daily basis? :wq (Or ZZ) Steve Orr -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Orr, Steve INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Dwayne Cox Corporate Database Administrator Info Tech, Inc. 5700 SW 34th Street, Suite 1235 Gainesville, FL 32608 email: [EMAIL PROTECTED] phone: 352.381.4521 fax: 352.381. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Dwayne Cox INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: Emacs on SQLPlus, er uh... SQLPlus on emacs.
Hi I use vi on Unix and textpad on windoze. I like to write macros for vi so it types repetitive code for me...:-), although I should probably use an editor with more powerful macro facilities. cheers Pete -- Pete Finnigan email:[EMAIL PROTECTED] Web site: http://www.petefinnigan.com - Oracle security audit specialists Book:Oracle security step-by-step Guide - see http://store.sans.org for details. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pete Finnigan INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: Emacs on SQLPlus, er uh... SQLPlus on emacs.
> Of course, there are those who use notepad + ftp That's me. v/r Stephen S. Wolfe, GS-11, DAFC Data Services Manager [EMAIL PROTECTED] (813) 827-9974 DSN 651-9974 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Wolfe Stephen S GS-11 6 MDSS/SGSI INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: Emacs on SQLPlus, er uh... SQLPlus on emacs.
My editor of choice is UltraEdit-32 from IDM, especially since the intergrated FTP into the editor. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Friday, July 25, 2003 4:24 PM To: Multiple recipients of list ORACLE-L It seems like DBAs that use Emacs over vi (emacs vs. vi being the classic UNIX holy war) tend to be people who were introduced to UNIX by being either a developer or an end-user. If a DBA favors vi over emacs, it seems that they generally come from a sysadmin background. That's how I ended up a vi user - none of the systems I was ever working on could be counted to have any editor OTHER than vi. For better or worse, its the ubiquitous UNIX text editor. Of course, there are those who use notepad + ftp Matt -- Matthew Zito GridApp Systems Email: [EMAIL PROTECTED] Cell: 646-220-3551 Phone: 212-358-8211 x 359 http://www.gridapp.com > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On > Behalf Of Orr, Steve > Sent: Friday, July 25, 2003 3:10 PM > To: Multiple recipients of list ORACLE-L > Subject: Emacs on SQLPlus, er uh... SQLPlus on emacs. > > > vi is what I use and it's the predominant editor for > SysAdmin/DBA types but I'm curious as to how many DBA's use > emacs. I just saw a demo of SQL*Plus running under emacs and > it was quite functional... Sorta like and IDE for SQL without > Windoze GUI dependencies. Any DBA's use emacs on a daily basis? > > :wq (Or ZZ) > Steve Orr > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Orr, Steve > INET: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: Matthew Zito INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: Goulet, Dick INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: Emacs on SQLPlus, er uh... SQLPlus on emacs.
It seems like DBAs that use Emacs over vi (emacs vs. vi being the classic UNIX holy war) tend to be people who were introduced to UNIX by being either a developer or an end-user. If a DBA favors vi over emacs, it seems that they generally come from a sysadmin background. That's how I ended up a vi user - none of the systems I was ever working on could be counted to have any editor OTHER than vi. For better or worse, its the ubiquitous UNIX text editor. Of course, there are those who use notepad + ftp Matt -- Matthew Zito GridApp Systems Email: [EMAIL PROTECTED] Cell: 646-220-3551 Phone: 212-358-8211 x 359 http://www.gridapp.com > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On > Behalf Of Orr, Steve > Sent: Friday, July 25, 2003 3:10 PM > To: Multiple recipients of list ORACLE-L > Subject: Emacs on SQLPlus, er uh... SQLPlus on emacs. > > > vi is what I use and it's the predominant editor for > SysAdmin/DBA types but I'm curious as to how many DBA's use > emacs. I just saw a demo of SQL*Plus running under emacs and > it was quite functional... Sorta like and IDE for SQL without > Windoze GUI dependencies. Any DBA's use emacs on a daily basis? > > :wq (Or ZZ) > Steve Orr > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Orr, Steve > INET: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: Matthew Zito INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
