Can we create a unique foreign key constraint on a child-table without having to create a unique index also?
Our DB is a 11g Enterprise Edition Release 11.2.0.4.0 .
I.e. like ALTER TABLE products ADD CONSTRAINT fk_supplier UNIQUE FOREIGN KEY (supplier_id) REFERENCES supplier(supplier_id);
So in our products child-table, the foreign key is unique. I.e. a supplier can supply only ONE product in our unique/unusual setup.