exlude parameters values if null from the where condtion
Hi All
Is there any possiblility to avoid null values from a where condition
for example where conditon like
cursor get_cust is
select from customer*
where customer_id = customer_
sometimes null valius can be passed to customer_ , in this case it returns empty rows, instead i should be able to exclude filtering the customer_id if the customer_ is null ( if the customer_ parameter is null then i should get the complet row set excluing the filter)
is ther any way of writing this without dynamic sql. cusomter_id field is always bears value.
Thanks
Prash