accept a variable in sqlplus

[ManjulaMadhu]

Hi,

I have a script that accepts a variable and then some queries with this variable.

eg:
set pages 0
set feedback off

accept new prompt seqid

Select count(*) from T_LE_PROFILE Where le_id >= &new
and rownum < 5;

Select count(*) from T_LE_ADDR Where le_id >= &new and rownum < 5;

Now, when the script is run , I get the output as old, new values of the select with the varaiable values and the output.
How can I just get the output of the query surpassing the old and new values ?

Thanx in advance,

 

[ManjulaMadhu]

Hey,

I got it.

set verify off

Thanks for your time,anyway