SELECT 
    table_name,
    constraint_name,
    constraint_type,
    search_condition
FROM 
    all_constraints
WHERE 
    owner = (SELECT user FROM dual); -- Selects constraints owned by the current user