oracle中复制数据表的同时新增一列
CREATE TABLE ACCOUNT_20200520 AS select ACCOUNT.,‘6666’ lifecycle FROM ACCOUNTalter table ACCOUNT_20200520 add (lifecycle varchar2(100))insert into ACCOUNT_20200520 select ACCOUNT.,‘6666’ lifecycle from ACCOUNT
原创
2020-06-15 17:24:31 ·
796 阅读 ·
0 评论