Title: (Optional) Write a table- and column-level constraint.
Course: Database Design and Management (Oracle) (10052) > Section: Defining Database Constraints

Writing should be created at the time of table creation; syntax should follow these examples:

- Column-level constraint (demonstrates PRIMARY KEY and NOT NULL at the column level)

CREATE TABLE Employee
(EmpID NUMBER(4) CONSTRAINT Employee_EmpID_PK PRIMARY KEY
EmpLN VARCHAR2(40) CONSTRAINT Employee_EmpLN_NN NOT NULL)

- Table-level constraint (demonstrates PRIMARY KEY at the table level, with NOT NULL at the column level)

CREATE TABLE Employee
(EmpID NUMBER(4) EmpLN VARCHAR2(40) CONSTRAINT Employee_EmpLN_NN NOT NULL
CONSTRAINT Employee_EmpID_PK PRIMARY KEY(EmpID))