Oracle : sql - show all constraint
sql : show all constraint
select * from all_constraints where constraint_name = 'SYS_C0021041';
sql : show all constraint of a table
SELECT constraint_name, constraint_type, column_name from user_constraints natural join user_cons_columns where table_name = 'ARRIVAL_NOTIFICATION';