Chapter 12 데이터 정의어
CREATE TABLE EMP_HW (
EMPNO NUMBER(4),
ENAME VARCHAR2(10),
JOB VARCHAR2(9),
MGR NUMBER(4),
HIREDATE DATE,
SAL NUMBER(7, 2),
COMM NUMBER(7, 2),
DEPTNO NUMBER(2)
);
ALTER TABLE EMP_HW
ADD BIGO VARCHAR2(20);
ALTER TABLE EMP_HW
MODIFY BIGO VARCHAR2(30);
ALTER TABLE EMP_HW
RENAME COLUMN BIGO TO REMARK;
INSERT INTO EMP_HW
SELECT EMPNO, ENAME, JOB, MGR, HIREDATE, SAL, COMM, DEPTNO, NULL FROM EMP;
DROP TABLE EMP_HW;