RE: simple sqlplus question

Thanks for all the replies. But I still got 

Enter value for schema_name: dev72upd

         1    


How could I get rid off the line "Enter value for schema_name: dev72upd"
also in the spooled file?

Guang

-----Original Message-----
From: Knight, Jon [mailto:jknight@xxxxxxxxxxxxxx]
Sent: Monday, April 11, 2005 11:48 AM
To: 'GMei@xxxxxx'; Oracle-L (E-mail)
Subject: RE: simple sqlplus question


set verify off

Thanks,
Jon Knight

 -----Original Message-----
From:   oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Guang Mei
Sent:   Monday, April 11, 2005 10:42 AM
To:     Oracle-L (E-mail)
Subject:        simple sqlplus question

--sql script t1.sql

set hea off;
set echo off;

spool t1_out

select rid
from   &&schema_name..customers
where rid=1;

spool off

----------


And when I ran the above script, I got in my spooled file:


Enter value for schema_name: dev72upd
old   2: from   &&schema_name..customers
new   2: from   dev72upd.customers

         1     


Which sqlplus command should I use in my t1.sql so that I only see "1" (the
last line) in my spooled file?

TIA.

Guang


************************************************************************* 
PRIVILEGED AND CONFIDENTIAL: 
This communication, including attachments, is for the exclusive use of
addressee and may contain proprietary, confidential and/or privileged
information.  If you are not the intended recipient, any use, copying,
disclosure, dissemination or distribution is strictly prohibited.  If you
are not the intended recipient, please notify the sender immediately by
return e-mail, delete this communication and destroy all copies.  
*************************************************************************
--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l

************************************************************************* 
PRIVILEGED AND CONFIDENTIAL: 
This communication, including attachments, is for the exclusive use of
addressee and may contain proprietary, confidential and/or privileged
information.  If you are not the intended recipient, any use, copying,
disclosure, dissemination or distribution is strictly prohibited.  If you
are not the intended recipient, please notify the sender immediately by
return e-mail, delete this communication and destroy all copies.  
*************************************************************************
--
http://www.freelists.org/webpage/oracle-l

Other related posts: