将复杂的Oracle PL / SQL游标逻辑封装为视图的最佳方法是什么？

I've written PL/SQL code to denormalize a table into a much-easer-to-query form. The code uses a temporary table to do some of its work, merging some rows from the original table together.I've written PL/SQL code to denormalize a table