Finding constraints by name in Oracle:

SELECT *
FROM
        all_cons_columns
WHERE 1=1
and constraint_name = 'SYS_C003548'
   
ORDER BY
    position;