DEFAULT 칼럼 추가

CREATE TABLE dept6
AS
SELECT dcode, dname
FROM dept2
WHERE dcode IN(1000, 1001, 1002);

 

SELECT * FROM dept6;

 

ALTER TABLE dept6
ADD (location VARCHAR2(10));

 

기본값 설정

ALTER TABLE dept6
ADD (location2 VARCHAR2(10) DEFAULT 'SEOUL');