lab8_1.sql

9iSQL新特性试验

CREATE TABLE MY_EMPLOYEE
(ID         NUMBER(4) CONSTRAINT MY_EMPLOYEE_ID_NN   NOT NULL,
 LAST_NAME  VARCHAR2(25),
 FIRST_NAME VARCHAR2(25),
 USERID     VARCHAR2(8),
 SALARY     NUMBER(9,2)
);