oracle 复制表 复制表结构 复制插入数据 行转列 列转行

–创建复制表结构和表数据
create table new as select cloums from old ; //cloums字段
–创建表复制表结构但不复制表数据
create table new as select cloums from old where 1<>1;//1<>1不成立
–复制数据且2张表必须存在
insert into new(cloums) select ocl from old;
*–复制数据且2张表必须存在[mysql]
–[mysql] select * into new form old; //oracle 不能用

–行转列 pivot
select * from (
select str
from A
)
pivot
(
max(str)
for str in (‘a’ as a,‘b’ as b,‘c’ as c,‘d’ as d)
);

--------------------------------------------（oracle father）-------------------------------------------------------
– unpivot 列转行
select “value”
from b
unpivot
(
“value”
for “key” in (A1,B1,C1,D1)
)
更多关于pivot和unpivot请参考oracle官网