oracle sqlplus

select TABLE_NAME, CONSTRAINT_NAME, STATUS
from USER_CONSTRAINTS
where TABLE_NAME like 'INVOICE';

the word after 'like' must be in capital, otherwise you won't get any result