Month: January 2010

CREATE TABLE EMPLOYEE3 AS
   (SELECT PROJNO, PROJNAME, DEPTNO
    FROM EMPLOYEE
    WHERE DEPTNO = 'D11') WITH NO DATA

MUST USE "WITH NO DATA"  at the end of statement - bullshit fibm