常用SQL語句（ORACLE）_不斷更新中

alter table table_name add (col1 type,col2 type); 


ALTER TABLE TABLE_AAA ADD (STOCKMAN NUMBER(18))//添加一列 

COMMENT ON COLUMN TABLE_AAA.STOCKMAN IS '管理人員' //給列添加注釋 

ALTER TABLE TABLE_AAA ADD CONSTRAINT FK_TABLE_AAA_R_TABLE_BBB_S FOREIGN KEY (STOCKMAN) REFERENCES TABLE_BBB (ID)//給列添加外鍵