
复制CONNECT TO SAMPLE ... ALTER TABLE EMPLOYEE ADD UNIQUE (EMPNO) ALTER TABLE DEPARTMENT ADD UNIQUE (DEPTNO) CREATE TABLE EMP AS (SELECT E.EMPNO,数据 E.FIRSTNME, E.LASTNAME, E.PHONENO, D.DEPTNO, SUBSTR(D.DEPTNAME, 1, 12) AS DEPARTMENT, D.MGRNO FROM EMPLOYEE E, DEPARTMENT D WHERE E.WORKDEPT = D.DEPTNO) DATA INITIALLY DEFERRED REFRESH IMMEDIATE SET INTEGRITY FOR EMP IMMEDIATE CHECKED NOT INCREMENTAL 1.2.3.4.5.6.7.8.9.


相关文章

精彩导读

热门资讯
关注我们
