For performance purposes I want to copy a view into a temp table before starting a SP that contains a cursor and multiple loops.
I found an example of creating the table
CREATE GLOBAL TEMPORARY TABLE my_temp_table (
) ON COMMIT PRESERVE ROWS;
But the view has about 30 columns and I want to know if there is an easier way to do a copy besides defining every column i.e can I do something like this
CREATE GLOBAL TEMPORARY TABLE my_temp_table AS
( SELECT *
)ON COMMIT PRESERVE ROWS;