CREATE TABLE <table_name> AS
SELECT <column_name, column_name, ..., column_name>
FROM <table_name>;
SELECT <column_name, column_name, ..., column_name>
FROM <table_name>;
Fuentes
http://psoug.org/reference/select.htmlhttp://www.orafaq.com/wiki/CTAS
http://www.dba-oracle.com/t_create_table_select_ctas.htm
No hay comentarios:
Publicar un comentario