Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: problems with sql*plus buffer

Re: problems with sql*plus buffer

From: Galen Boyer <galenboyer_at_hotpop.com>
Date: 12 Oct 2002 22:15:18 -0500
Message-ID: <ud6qe26xp.fsf@hotpop.com>


On 9 Oct 2002, pablo_at_dev.null wrote:
> TurkBear <john.greco_at_dot.state.mn.us> wrote in
> news:3mk8qu0aig9pno27u00m7t1ko94832ifph_at_4ax.com:
>

>> 
>> SqlPlus is not a scripting too ( as you have discovered)l..Try
>> SqlPlus Worksheet -  It has editing and command history features..

>
> For the emacs-savvy, the can download xemacs to their windows
> machines
> and open a shell to start a sql*plus session. Once within the emacs
> session, you can do what you please: cut 'n paste, walk through
> history, etc.
>
> For those seeking an example of what the init.el ought to look like
> ... word wrap might screw things up so beware ... :)
>
> (defun sqlplus-shell-exec (my-buffer-name login-string)
> (require 'shell)
> (start-process-shell-command "sqlplus" my-buffer-name "sqlplus"
> login-string)
> (switch-to-buffer-other-window my-buffer-name)
> (shell-mode)
> )

Excellent to hear from other Emacs users. I've tried various sqlplus specific packages. There is also a sql.el that comes with the stock version of Emacs. This piggybacks on comint-mode so all the shell history and execution facilities are at sqlplus prompt.

Best of both worlds to me, sqlplus's utility/power and simplicity and Emacs's editing and history and buffer management.

-- 
Galen deForest Boyer
Sweet dreams and flying machines in pieces on the ground.
Received on Sat Oct 12 2002 - 22:15:18 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US