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