CODE EXAMPLE FOR SQL

oracle optional field procedure

-- Function can be called with 1 or 2 parameters
FUNCTION xxxx( 
  param_one  NUMBER,
  param_two  VARCHAR2  DEFAULT NULL )
RETURN VARCHAR2;