Help Needed - Varying Input Problem

From: <pankaj_wolfhunter_at_yahoo.co.in>
Date: Thu, 07 Jun 2007 03:07:06 -0700
Message-ID: <1181210826.222942.284220@q69g2000hsb.googlegroups.com>

Greetings,

The requiremnt gathers a set of inputs from from end and based on these input conditions we have to fetch values from our db tables.

Preety simple but the problem here is the inputs are not fixed.

Say in all, we have 10 inputs in our front end but the user only selects 5 of them or may be 2 or all 10.

How should I build by query so it takes all the valid inputs.

One way is so use a set of if...else. But is there any other alternative?
Can I use case statement here? Can I achieve this in a single statement?

Any help would be appreciated.

We are using Oracle 9i.

TIA Received on Thu Jun 07 2007 - 05:07:06 CDT