oracle表复制

select * into dest_tab from res_tab;

执行报错误ORA-00905: 缺失关键字错误

select..into is part of PL/SQL language which means you have to use it inside a PL/SQL block. You can not use it in a SQL statement outside of PL/SQL.

--要求目标表是存在的

insert into dest_tab select * from res_tab;

oracle sql中可以用自动建表（目标表不存在）

create table dest_tab as
select * FROM res_tab;