Re: sqlplus command history: rlwrap and multiple line sql statements

From: NetComrade <netcomradeNSPAM_at_bookexchange.net>
Date: Mon, 03 Oct 2005 20:53:51 GMT
Message-ID: <43419a08.15245453@localhost>

On Sun, 02 Oct 2005 02:23:57 +1000, Noons <wizofoz2k_at_yahoo.com.au> wrote:

>NetComrade apparently said,on my timestamp of 29/09/2005 6:15 AM:
>
>> Great for one-liners, but what about multiple lines?
>>
>> We use Oracle 8.1.7.4 and 9.2.0.6/7 on Solaris 2.7 and RH4
>> remove NSPAM to email
>
>
>define _editor=vim

I think people mis-understood my question. rlwrap is used to add command history to sqlplus http://www.dizwell.com/html/cli_history.html however, it cannot recall the full sql command, if the command wrapped for longer then one line
I do know how to use vi and 'edit' in sqlplus.

thanks.
.......
We use Oracle 8.1.7.4 and 9.2.0.6/7 on Solaris 2.7 and RH4 remove NSPAM to email Received on Mon Oct 03 2005 - 15:53:51 CDT