RE: Command History in SQL*PLUS

Try CPAN. There's some free wrappers out there:

"MyOracle" emulates MySQL but it's a bit clunky and has bad error handling on exit.

"fsql" is written in C and is fast but has very limited login capability. It does not mimic MySQL's show tables command.

"YASQL" (Yet another SQL) is also a Perl wrapper but it's not bad. Show tables works and the up arrow is OK. Has good login capability for SQL*Net but it echos passwords to the screen.

The best approach is to just get over MySQL addiction and learn to love SQL*Plus with all it's shortcomings. :-)

Steve Orr

-----Original Message-----
Sent: Wednesday, July 18, 2001 2:07 PM
To: Multiple recipients of list ORACLE-L

On HP-UX use 'ied' command to launch sql*plus or svrmgrl session (% ied sqlplus) . Esc-K will recall previous SQL commands (just like setting 'set -o vi' in a KSH)
Check out a script #10 at http://www.orafaq.com/faqscrpt.htm#UNIX. It is wrapper for sqlplus and svrmgrl to do similar things.

On NT, I guess use your arrow keys... (Not sure of that, though)..

HTH, Regards.

• Kirti Deshpande Verizon Information Services http://www.superpages.com

> -----Original Message-----
> From: Rama Malladi [SMTP:rama_at_toyota.com]
> Sent: Wednesday, July 18, 2001 2:36 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Command History in SQL*PLUS
>
> Sometime ago there was a post on how to get the last commands executed
> in SQL*Plus. It is very similar to doing escape from the UNIX command
> line....
>
> Do you know how to scroll down the last 10-20 commands executed in
> SQL*Plus ? I am not talking about "/" which would get the last command.
>
> Rama
>
> --

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Deshpande, Kirti
  INET: kirti.deshpande_at_verizon.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Orr, Steve
  INET: sorr_at_rightnow.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).