Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> UNIX sqlplus can't echo multiline commands in order

UNIX sqlplus can't echo multiline commands in order

From: <yong321_at_yahoo.com>
Date: 3 Oct 2006 20:14:21 -0700
Message-ID: <1159931661.155091.160270@b28g2000cwb.googlegroups.com>


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. Can anybody offer a suggestion? One way is to save the multi-line input to a file myscript.sql and run it with @myscript.sql. Perhaps some third party sqlplus replacement can also do it. Any other suggestion?

At first I thought this was related to the shell I launched sqlplus from, because at least on my bash shell window, pasting multiple lines of "sleep 1" echos them back one line at a time. But going into sqlplus, I still have the above problem. (I posted a message about that "sleep 1" problem here:
http://groups.google.com/group/comp.unix.shell/browse_frm/thread/b78159e69d1f63ad )

Yong Huang Received on Tue Oct 03 2006 - 22:14:21 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US