将视图直接转换成表的SQL语句

oracle :
create table tablename as select * from viewname

sqlserver:
select * into tablename from viewname