how do you see the query given for materialized views ?
I tried using dba_snapshots? but i could not read the entire query ?
is there any other view which can show this query ?
Printable View
how do you see the query given for materialized views ?
I tried using dba_snapshots? but i could not read the entire query ?
is there any other view which can show this query ?
The query column has data type "LONG". In SQL*Plus type ...
set long 10000
... then run the select.
IT WORKED THANKS!!