Hi all.
I'd like use a temporary view "to hide" a non-temp one for some queries.
Later I'd need to drop that view in order to "revert to normal operations".
As there is no "DROP TEMPORARY VIEW ..." I'd be forced to "CREATE OR
REPLACE TEMPORARY VIEW ..." in order to "overwrite" the temporary one
with the same code as the non-temporary.
All this sounds quite complex to me. Is there a way to drop temporary
stuff before closing the session?
TIA.
--
Vincenzo Romano - NotOrAnd.IT
Information Technologies
NON QVIETIS MARIBVS NAVTA PERITVS