span8
span4
CREATE TABLE hr.admin_emp(EMPNO NUMBER(5)PRIMARY KEY,ENAME VARCHAR2(15)NOT NULL,SSN NUMBER(9)ENCRYPT,作业VARCHAR2(10),MGR NUMBER(5),HIREDATE DATE DEFAULT(SYSDATE),照片BLOB, sal NUMBER(7,2), hrly_rate NUMBER(7,2) GENERATED ALWAYS AS (sal/2080), comm NUMBER(7,2), deptno NUMBER(3) NOT NULL CONSTRAINT admin_dept_fkey REFERENCES hr.departments (department_id)) TABLESPACE admin_tbs STORAGE ( INITIAL 50K);
©2019安全亚搏在线软件公司|法律