【sql】

create table A表 as select * from B where 1>2

创建A表并复制B表的结构

insert into 
A表 select * from B表

插入B表的数据
decode
listagg
withgroup
nvl
when
then
case then

count
sum
union
<>