| EMPNO | ENAME | JOB | MGR | HIREDATE | SAL | COMM | DEPTNO |
|---|---|---|---|---|---|---|---|
| 7329 | SMITH | CEO | N/A | 17-DEC-85 | 9,000.00 | N/A | 20 |
| 7499 | ALLEN | VP-SALES | 7329 | 20-FEB-90 | 7,500.00 | 100.00 | 30 |
| 7521 | WARD | MANAGER | 7433 | 22-FEB-90 | 5,000.00 | 200.00 | 30 |
| 7566 | JONES | SALESMAN | 7521 | 02-APR-90 | 2,975.00 | 400.00 | 30 |
| - | NOT NULL Constraint (no row may contain a null value for this column) | - | - | - | - | Absence of NOT NULL Constraint (any row can contain a null for this column) | - |
The constraint on ENAME is specified by: ALTER TABLE "emp" MODIFY "ENAME" NOT NULL.