Re: SQLPLUS editor

"hwchui" <hwc33_at_hotmail.com> wrote in message news:<a6bovf$26310_at_imsp212.netvigator.com>...
> In sybase, isql, I can call up a editor and type two sql. when I return
> to isql, the two sql will be run.
>
> like
> select getdate()
> select name from sysobject
>
>
> but in oracle sqlplus, when editor is called , I find I cannot type more
> than one sql statement.
>
> Is this the limit of sqlplus?
>
>
> Thanks in advance.
> Wingman

If you fire up edit you are editing the sql buffer. A sql buffer can contain only one statement. Save the first statement to a file
ed <filename>
_at_<filename>
and you should be set.
Obviously this behavior is described in the sql*plus reference manual. Please try to read it.

Regards

Sybrand Bakker
Senior Oracle DBA Received on Mon Mar 11 2002 - 11:12:19 CET