> Can anyone help me with creating temporary tables in place of the views,
> which are available during runtime, which have the same fields and data
> as my view such that when one table is updated, the results are appended
> to the temporary table

Why not just insert the content of the view into the temp table?

insert into tmp_view_1
  select * from view_1

Reply via email to