Re: UNIX sqlplus can't echo multiline commands in order

Malcolm Dew-Jones wrote:
> yong321_at_yahoo.com wrote:
> : I''m sure everyone has seen this. If I copy
>
> : select * from dual;
> : select * from dual;
> : select * from dual;
> : select * from dual;
>
> : from my Windows clipboard and paste them all into sqlplus running on
> : UNIX or Linux, the screen looks like this:
>
> : SQL> select * from dual;
> : select * from dual;
> : select * from dual;
> : select * from dual;
>
> : D
> : -
> : X
>
> : SQL>
> : D
> : -
> : X
>
> : SQL>
> : D
> : -
> : X
>
> : SQL>
> : D
> : -
> : X
>
> : If I do this to DOS sqlplus, I don't have this problem.
>
> What exactly is the problem? It looks like typical unix output to me.
> You pasted in four commands and sqlplus ran four commands.

Sorry I didn't explain it clearly. What I want to see is one command sent, then one result shown on screen, then the next command and then the result, like this:

SQL> select * from dual;

DU

--
X

SQL> select * from dual;

DU
--
X

SQL> select * from dual;

DU
--
X

It's not a big deal if there're only a few lines. But if I paste for
instance tens of lines of PL/SQL code into UNIX sqlplus, the code is
mixed with "SQL>" shown in unpredictable places on screen. It's not
easy to read.

Yong Huang