Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: History alias for sql/sqlplus cmd?
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 DBAReceived on Fri May 04 2007 - 14:06:58 CDT
![]() |
![]() |