Re: SQLPLUS Oracle 8i query

From: Cris Carampa <>
Date: Thu, 20 Jul 2006 10:35:45 +0200
Message-ID: <44bf4062$0$969$> 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
There's still no need for procedural statements here:

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

Cris Carampa (
  when they kick at your front door | how you gonna come ?
  with your hands on your head      | or on the trigger of your gun ?
Received on Thu Jul 20 2006 - 10:35:45 CEST

Original text of this message