Reputation: 15
Is it possible to assign the o/p of a procedure, with result view, to a temp table in procedure. Please advise how can this be done. Thanks.
Upvotes: 0
Views: 650
Reputation: 39
You can use
INSERT INTO temp_table (SELECT * FROM view_name);
Upvotes: 1