我们可以在oracle中命名默认约束吗？

CREATE OR REPLACE TRIGGER my_table_trigger
AFTER INSERT ON my_table
FOR EACH ROW
BEGIN
  IF :NEW.my_column IN (1, 2, 3) THEN
    -- 应用默认约束
    UPDATE my_table
    SET my_column = :NEW.my_column
    WHERE my_column = :OLD.my_column;
  END IF;
END;

CREATE OR REPLACE PROCEDURE apply_default_constraint
(
  p_table_name IN VARCHAR2
)
AS
BEGIN
  UPDATE my_table
  SET my_column = my_column
  WHERE my_column = (SELECT my_column FROM my_table WHERE my_table.name = p_table_name);
END;