Re: problems with sql*plus buffer

I don't disagree with you. You just can;t do it in SQL*Plus. Buffer holds the last (or current) command only, and not even that if you mispell the first keyword. You can do some editting hence the list command. It's just not a real editor that's all so limited.

I tend to use tools like TOAD or SQL*Navigator myself for SQL development and so have all my scripts available. I would suggest you get yourself a free (if it still is) copy of TOAD.

Don't give up on SQL*Plus though. Do get to learn it. It;s the only tool that guaranteed to be there!

Alan

"Michael L. Hostbaek" <carlos_at_pez.dk> wrote in message news:slrnaq887h.1faq.carlos_at_freebsdcluster.dk...
> hmmm.. what is the use of the 'list' command then ? I mean, you should
> be able to issue a list command to see the last XX commands in the
> history buffer.
>
> I know editing is hopless in sql*plus - however I will not make OS files
> for every little command I am writing. I would like to be able to select
> fx. the third last command and re-run it.. it should be possible..
>
> /mich
>
> Alan Mills tried to tell us something, and all I got was:
> > As far as I know, you can't do that.
> >
> > Save your scripts as OS files and execute them with the 'start' command
or
> > open them for editing with the 'get' command.
> >
> > You're better off editting them as OS files anyway. SQL*Plus is hardly
the
> > best editor any of us has seen is it?
> >
> > "Michael L. Hostbaek" <carlos_at_pez.dk> wrote in message
> > news:slrnaq82hk.1e5r.carlos_at_freebsdcluster.dk...
> > > Group,
> > >
> > > When using the sql*plus - I have probs. with my buffer. When I type
list
> > > it only shows the last command... I would like for it to keep a longer
> > > history... how do I do that?
> > >
> > > thanks
> > >
> > >
> > > --
> > > Regards,
> > > Michael L. Hostbaek
> > > -= So long, and thanks for all the fish.. =-
> > >
> >
> >
>
>
> --
> Regards,
> Michael L. Hostbaek
> -= So long, and thanks for all the fish.. =-
>
Received on Wed Oct 09 2002 - 07:59:34 CDT