title: check the null values for input parameters with oracle stored procedure
body: <p>I am preparing stored procedure with oracle .I m using multiple inner joins with the same table where an input parameter value is checked within each inner join. I want to eliminate particular inner join if the input parameter is null</p>