SQLPLUS Oracle 8i query

From: <vernalGreens_at_gmail.com>
Date: 20 Jul 2006 00:00:22 -0700
Message-ID: <1153378822.322886.210690_at_s13g2000cwa.googlegroups.com>



select * from tablename
where
country = 'abc'
and city = 'xyz'

[Quoted] [Quoted] I want to modify the query so that "and city = 'xyz'" run only when region = pqr.

select * from tablename
where
country = 'abc'
if region = 'pqr' then

    and city = 'xyz'
end if

What's the exact syntax for doing this in SQLPLUS. I'm using oracle 8i. Received on Thu Jul 20 2006 - 09:00:22 CEST

Original text of this message