Home » RDBMS Server » Server Administration » urgent...
urgent... [message #58753] Mon, 29 September 2003 10:26 Go to next message
Kapil
Messages: 145
Registered: May 2002
Senior Member
i just typed something like this on sqlplus session.

select * from tab where id=111;
and then i did something like this
select * from tab;
now i forgot the id i put in b4 last cmd, i want see the comman i typed b4 last. how will i be able to do this.
Re: urgent... [message #58754 is a reply to message #58753] Mon, 29 September 2003 10:49 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
u cannot do it using sqlplus GUI.
ie by default when u click icon '+ ' it opens sqlplusw.exe
instead use sqlplus.exe from command prompt, which is command line mode.
you can use Uparrow to get the previous command

Re: urgent... [message #58758 is a reply to message #58754] Mon, 29 September 2003 11:45 Go to previous messageGo to next message
Kapil
Messages: 145
Registered: May 2002
Senior Member
Well I know about the up arrow, and i am using sqlplus from cmd prompt. but its not there any more in the screen. is there anyway that i can see the history of the cmd i type in that session?
Re: urgent... [message #58759 is a reply to message #58758] Mon, 29 September 2003 11:50 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
NOpe.
you cannot 'see' the history.
but you can get back the commands u executed before

Re: urgent... [message #58760 is a reply to message #58759] Mon, 29 September 2003 11:51 Go to previous messageGo to next message
Kapil
Messages: 145
Registered: May 2002
Senior Member
How ? can u please tell me .how to get back to those cmds.
Re: urgent... [message #58761 is a reply to message #58760] Mon, 29 September 2003 11:57 Go to previous message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
use sqlplus.
 
like
c: sqlplus mag/mag@somedb

select .... first query;
select .... second query;
..
..
now hit up arrow key, to browse through the previious commands, one by one. ( just like you do in dos or bash shell!!)

Previous Topic: SetSystem DBOptions, SetDBOptions
Next Topic: General Oracle script.
Goto Forum:
  


Current Time: Wed Jan 29 12:48:58 CST 2025