These two cases produce no differences in schema comparisons (11.6 and 12.1). The end result is the same after the constraint is applied, but the DDL is still technically different since the explicit constraint is not defined on the columns. The Toad generated DDL does generate it properly with the differences. Drop the PK and they do pop up on the Colmns|nullability list.
Table DDL:
Case 1:
CREATE TABLE SPF.EE
(
BADGE_ID VARCHAR2(8) NOT NULL,
DATA_DT DATE NOT NULL,
ALTER TABLE SPF.EE ADD (
CONSTRAINT EE_PK
PRIMARY KEY
(BADGE_ID, DATA_DT)…
Case 2:
CREATE TABLE SPF.EE
(
BADGE_ID VARCHAR2(8),
DATA_DT DATE,
ALTER TABLE SPF.EE ADD (
CONSTRAINT EE_PK
PRIMARY KEY
(BADGE_ID, DATA_DT)…