Big
Planet wrote
-I
am writing this proc does a searchin databasebased on these in
parameters and returns a ref cursor . Now one moreofthesein
parameters can be null and my query should return data neglecting null
parameters . So I use nvl in the query as shown below
Big Planet, small
BigP,
You
could have an If Then ElsIf...Else statement that tested the input arguments of
interest (looks like p_loginid and p_firstname), each part having an appropriate
Select that did not use NVL if that input argument was Not Null. In
essence, you'd be tailoring your Ref Cursor to the