Materialized views 1

[bjoern6689]

Hi

I need help on finding the query part of a materialized view created by another user. Do anyone know a dba_ table or v$ view where I can find that?

 

[stefanhei]

I think the query column in dba_snapshots is what you're looking for (it's long-format though).

Stefan

 

[bachidba]

I should fetch the records from the table.. where
the table_name is fetched from another query.

and that table _name is part of a column_name in other table.