OK..

Great for one-liners, but what about multiple lines?

Thanks.
........
We use Oracle 8.1.7.4 and 9.2.0.6/7 on Solaris 2.7 and RH4
remove NSPAM to email

You can use / to repeat the previous sql statement. Oracle advise to
use iSQLplus and there you can edit your statements.

Best regards,
Primoz Mihelic

http://www.twisted-nail.com

> Great for one-liners, but what about multiple lines?
I use vim.
Here's some kind of howto: http://oracledba.ru/notes_vim_en.html


--
Egor
http://www.oracledba.ru/orasrp/
Free Oracle Session Resource Profiler

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

--
Cheers
Nuno Souto
in sunny Sydney, Australia
wizofoz2k@yahoo.com.au.nospam

On Sun, 02 Oct 2005 02:23:57 +1000, Noons <wizofoz2k@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

NetComrade wrote:
> >
> >
> >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.
>

Didn't say you didn't, buddy. Just suggested you use
it. Because I don't think there is an exact parallel
with WIndows available in the Looneecks world.
Still, if there is I'd love to hear details.