When you create a new table in IntelliJ with a constraint on column STATUS
, it’s difficult later on to amend that constraint as Oracle assigns a random name for it
CREATE TABLE MY_TABLE (
ID NUMERIC(19,0) NOT NULL,
STATUS NVARCHAR2(20) NOT NULL CHECK (STATUS IN ('OPEN', 'CLOSED'));
);
What is the proposed effect on it? Getting a warning that it’s better to create column constraint using a separate statement like
ALTER TABLE MY_TABLE ADD CONSTRAINT STATUS_VALIDATION CHECK (STATUS IN ('OPEN', 'CLOSED'));