conditional selection of 'AND' or 'Select' in Oracle

From: Rohit Dhawan <rohit_reborn_at_yahoo.com>
Date: 16 Apr 2004 16:45:51 -0700
Message-ID: <c76d1c78.0404161545.550a50cb_at_posting.google.com>

[Quoted] [Quoted] 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 Received on Sat Apr 17 2004 - 01:45:51 CEST