Re: Materialized Views name

From: Bricklen <bricklen-rem_at_yahoo.comz>
Date: Wed, 14 Jul 2004 16:12:22 GMT
Message-ID: <GXcJc.55116$eO.16726@edtnps89>

darkeagle wrote:

> Hi,
> I have a question.
> Suppose we create many materialized view as this example:
> CREATE MATERIALIZED VIEW A [ ... ]
> CREATE MATERIALIZED VIEW B [ ... ]
> CREATE MATERIALIZED VIEW C [ ... ]
> Etc
>
> Exists a procedure that obtain a list of the names of all materialized view
> presents in the db?
> For this example the procedure output will be like this:
> A, B, C
>
> Thank you.
>
>

dba_mviews Received on Wed Jul 14 2004 - 11:12:22 CDT