On Fri, 20 Apr 2012 17:36:59 +0200
Vincenzo Romano <vincenzo.romano@notorand.it> wrote:
> 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.
DROP VIEW <view>
It will destroy the view, temporary or not...
Regards
Rodrigo
>
> --
> Vincenzo Romano - NotOrAnd.IT
> Information Technologies
> NON QVIETIS MARIBVS NAVTA PERITVS
>