Re: SQLPLUS editor

Have you tried ending each command with a ; ? eg
select sysdate from dual;
select username from dba_users;
...
Jim
"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
>
>
Received on Sat Mar 09 2002 - 03:18:51 CET