Passes multiple conditions
Can't passes multiple conditions
Act like 'Case' in pl/sql
Act as a 'where' condition