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

Home -> Community -> Usenet -> c.d.o.server -> How to echo sql statements in sqlplus

How to echo sql statements in sqlplus

From: <dbaplusplus_at_hotmail.com>
Date: 11 Dec 2005 18:19:02 -0800
Message-ID: <1134353942.542652.5520@o13g2000cwo.googlegroups.com>


I am using Oracle 9.2.0.5 on HP UNIX 11i

I have a shell script:

sqlplus << !
set echo on;
set feedback on;

select * from tab1;
select * from tab2;
select * from tab3;

!

I want statements such as select to be shown in addition to returned data from the select's. I thought that is purpose of set echo on. I do not see any difference in
set echo on;

or

set echo of; Received on Sun Dec 11 2005 - 20:19:02 CST

Original text of this message

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