oracle : create table tablename as select * from viewname sqlserver: select * into tablename from viewname