SqlServer select * into 对应 Oracle语法

创建新表,并插入旧表值

Sql Server

select * into new_emp from emp;

Oracle

create table new_emp as select * from emp;

 

posted @ 2017-07-31 20:07  Twang  阅读(699)  评论(0编辑  收藏  举报