Real Estate Out – Real Estate Tips and Property Guide

Why can’t we assign not null constraint as table level constraint in oracle? [closed]

CREATE TABLE employees ( last_name VARCHAR2(25) CONSTRAINT emp_lname_nn NOT NULL,...);

CREATE TABLE employees ( last_name VARCHAR2(25),...,... CONSTRAINT emp_lname_nn NOT NULL (last_name));

Why Oracle put restriction especially on NOT NULL CONSTRAINT?

Exit mobile version