0.创建表
create table table_name as select * from table_name_b;
1.oracle 修改表名
ALTER TABLE old_table_name RENAME TO new_table_name;(大写为系统命令)
2.Oracle通过altertable增删改列的语法
alter table tablename add (column datatype [default value][null/not null],…);
alter table tablename modify (column datatype [default value][null/not null],…);
alter table tablename drop (column);
alter table table_name rename column col_old to col_new;