CONSTRAINTS.SQL

-->>CONSTRAINTS


------>>>>>>>>>>>.<<<<<<<<<<<>>>>>>>>>>>>>>.<<<<<<<<<<<<------------ -->NOT NULL CONSTRAINTS
CREATE TABLE branch_mstr
(
branch_no VARCHAR2(10) CONSTRAINT branch_no_NN NOT NULL,
NAME VARCHAR2(20) CONSTRAINT name_NN NOT NULL
)

-->UNIQUE CONSTRAINTS
CREATE TABLE branch_mstr
(
branch_no VARCHAR2(10) CONSTRAINT branch_no_unq unique,
NAME VARCHAR2(20) CONSTRAINT name_NN NOT NULL
)
CREATE TABLE UNIQE
(
branch_no VARCHAR2(10) CONSTRAINT branch_no_unq unique,
NAME VARCHAR2(20) CONSTRAINT name_NN NOT NULL
)