> How different is a "*temp* materialized view" from a regular view?
If it existed, it would be useful for cases when you need to reference thatview in multiple queries in the same session. I've gotten around this byjust using temp tables.