Inspire growth, embrace learning
select ext_bank_account_id ,case when nvl(end_date,trunc(sysdate)) >= trunc(sysdate) then 'Active' else 'Inactive' end active_inactive from IBY_EXT_BANK_ACCOUNTS