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

Home -> Community -> Usenet -> c.d.o.server -> Re: History alias for sql/sqlplus cmd?

Re: History alias for sql/sqlplus cmd?

From: EscVector <Junk_at_webthere.com>
Date: 7 May 2007 07:06:11 -0700
Message-ID: <1178546771.125908.325930@q75g2000hsh.googlegroups.com>


On May 7, 2:26 am, Gints Plivna <gints.pli..._at_gmail.com> wrote:
> lazyboy..._at_yahoo.com wrote:
> > Hi Gurus,
>
> > Does oracle has a history alias (like unix) in sql/sqlplus which will
> > record all of your previous executed cmd + its syntax? I know that I
> > can run edit to get the most recent sql/sqlplus cmd, but I want to
> > retrieve the query which was run before that. Any sugguestions/ideas
> > are appreciated.
>
> > Thx,
> > -Chris
>
> Try F7. It works only in sqlplus not sqlplusw.
>
> Gints Plivnahttp://www.gplivna.eu

Using a cmd line sqlplus in Window gives the options for cut-n-past and arrow up/down cmd history and line completion if you set it up right. Never use the GUI Windows version...never... Received on Mon May 07 2007 - 09:06:11 CDT

Original text of this message

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