1、PLSQL下复制表
create table T_DJ_NSRXX_bf as select * from T_DJ_NSRXX
2、将一张表插入另一张表中
方式一: insert into b select * from a 方式二: insert into b (字段1,字段2) select 字段1,字段2 from a
3、连接两张表,包含所有字段结构
create table XX as select * from t1,t2 where 1=0;
1、PLSQL下复制表
create table T_DJ_NSRXX_bf as select * from T_DJ_NSRXX
2、将一张表插入另一张表中
方式一: insert into b select * from a 方式二: insert into b (字段1,字段2) select 字段1,字段2 from a
3、连接两张表,包含所有字段结构
create table XX as select * from t1,t2 where 1=0;