Here is one way to do it: Here is one way to do it: set head off; set echo off; set verify off; col schema_name new_value schema_name noprint prompt Enter Schema Name: set feed off term off select '&1' schema_name from dual; set feed on term on spool t1_out select cust_id from &&schema_name..customers where cust_id=1; spool off undef schema_name Jared On 4/11/05, Guang Mei <GMei@xxxxxx> wrote: > > 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. > ************************************************************************* > -- > //www.freelists.org/webpage/oracle-l > -- > //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. > ************************************************************************* > -- > //www.freelists.org/webpage/oracle-l > -- Jared Still Certifiable Oracle DBA and Part Time Perl Evangelist -- //www.freelists.org/webpage/oracle-l