1
SELECT DEPTNAME, MGRNO        FROM CORPDATA.DEPARTMENT        WHERE DEPTNO = 'C01'

1
2
3
INSERT INTO table-name (column1, column2, ... ) VALUES (value-for-column1, value-for-column2, ... )

INSERT INTO CORPDATA.EMPTIME (EMPNUMBER, PROJNUMBER, STARTDATE, ENDDATE) SELECT EMPNO, PROJNO, EMSTDATE, EMENDATE FROM CORPDATA.EMPPROJACT

1
UPDATE table-name SET column-1 = value-1, column-2 = value-2, ...  WHERE search-condition ...

1
DELETE FROM CORPDATA.EMPLOYEE WHERE WORKDEPT = 'D11'