Hi gang
I know you can create a table as select * from another table. But can you create a table as select * from a view_name?

create table AAA as select * from BBBB;
BBB is a view not a table.

Please advise.