Constraints All in Oracle

SELECT cols.column_name, cols.position, cons.status
FROM all_constraints cons, all_cons_columns cols
WHERE cols.table_name = 'EMP_HOLY_DAY'
AND cons.constraint_type = 'P'
AND cons.constraint_name = cols.constraint_name
AND cons.owner = cols.owner
ORDER BY cols.table_name, cols.position;

DISABLE
ALTER TABLE EMP_HOLY_DAY  disable CONSTRAINT EMP_HOLY_DAY_PK;
ALTER TABLE EMP_HOLY_DAY  enable  CONSTRAINT EMP_HOLY_DAY_PK;

DROP 
alter table receipt_detail drop constraint receipt_detail_itemcode_fk cascade 

alter table receipt_detail drop constraint receipt_detail_pk cascade