NULL при задании параметра SQL и HQL

HQL or SQL

from table t where ((:field is null and t.field is null) or t.field = :field)

SQL(Oracle)

SELECT ... FROM SOMETABLE WHERE COLUMN = NVL( INPUT_PARAM, COLUMN )

Ссылки по теме:
https://stackoverflow.com/questions/2123438/hibernate-how-to-set-null-query-parameter-value-with-hql
https://stackoverflow.com/questions/5014620/oracle-pl-sql-null-input-parameter-where-condition