[ORACLE] 테이블 생성, 추가, 변경, 삭제, 보기

[테이블 생성]
CREATE TABLE TABLE_NAME (COLUMN_NAME VARCHAR2(10), COLUMN_NAME VARCHAR2(10) DEFAULT '0'...);

[컬럼 추가]
ALTER TABLE TABLE_NAME
ADD (COLUMN_NAME1 VARCHAR2(10),
COLUMN_NAME2 VARCHAR2(10),
COLUMN_NAME3 VARCHAR2(10) DEFAULT '0'
);

[컬럼 삭제]
ALTER TABLE TABLE_NAME DROP COLUMN COLUMN_NAME;

[컬럼 수정]

ALTER TABLE TABLE_NAME MODIFY(COLUMN_NAME CHAR(3));

[COMMENT]
COMMENT ON COLUMN TABLE_NAME.COLUMN_NAME IS '코멘트';

[확인]
SELECT * FROM TABLE_NAME;

DESC TABLE_NAME;