I am working on Oracle reports . One of the parameters that a User
inputs is
'report_type'. Now, is there a way to do the following within a SQL
query with no use of procedures or functions.

select blaa from foo where

something = something
// if report_type='some_data' then
and somethingelse = something else
//else do nothing


Also, IS there a way of doing something like the following

// if report_type='some_data' then

select blaa from foo where
something = something
// if report_type='some_data' then
and somethingelse = something else
//else do nothing

else
select blass1 from foo where
something = something
// if report_type='some_data' then
and somethingelse = something else
//else do nothing

DECODE maybe? If that's what you're driving at??

Mark Stewart
Consultants Club Corp.

rohit_reborn (AT) yahoo (DOT) com (Rohit Dhawan) wrote in message news:<c76d1c78.0404161543.461586e3 (AT) posting (DOT) google.com>...

If you are using Oracle9i or above, try CASE.

CASE
WHEN something THEN
do this
WHEN something else THEN
do that
ELSE
don't do anything
END

hth

stewm (AT) canada (DOT) com (Mark T. Stewart) wrote in message news:<8b8ff667.0405072122.94134a1 (AT) posting (DOT) google.com>...