Oracle constraint so only one of several columns has a value
Suppose you had a users table that was generated with the following script:
create table users(
user_id number generated by default on null as identity,
home_phone varchar2(100) null,
work_phone varchar2(100) null
);
User's must have either a ...
talkapex.com2 min read