Re: SQLPLUS Oracle 8i query

vernalGreens_at_gmail.com wrote:

> If a user selected pqr from a dropdown on the webpage, only then I want
> the city statement to run.
>
> How can I achieve this in SQLPLUS (I think the syntax in the above
> query is incorrect). I'm using oracle 8i. Can I use conditional if in
> SQLPLUS?
There's still no need for procedural statements here:

select * from tablename
where country='abc'
and
(
('&&1'='pqr' and city='xyz')
or
('&&1'!='pqr')
) ;

-- 
Cris Carampa (spamto:cris119_at_operamail.com)
  when they kick at your front door | how you gonna come ?
  with your hands on your head      | or on the trigger of your gun ?