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: <sybrandb_at_hccnet.nl>
Date: Fri, 04 May 2007 21:06:58 +0200
Message-ID: <rt0n33h9707pojql2k1tlcl52rtacjloqk@4ax.com>


On 4 May 2007 11:48:13 -0700, "lazyboy_2k_at_yahoo.com" <lazyboy_2k_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

sql*plus doesn't have such a mechanism. SQL Worksheet (part of Oracle Enterprise Manager) does.
Obviously, this would be a question which is documented, but I appreciate, following your nick, you can't be bothered reading the manuals.

-- 
Sybrand Bakker
Senior Oracle DBA
Received on Fri May 04 2007 - 14:06:58 CDT

Original text of this message

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