In which dictionary table or view would you look to
determine at which time a snapshot or MVIEW last
successfully refreshed?
Answer / anuradha
USER_MVIEW_REFRESH_TIMES
This dictionary table lists the Materialized views and
their last refresh times for each master table that the
user can look at.
Is This Answer Correct ? | 1 Yes | 0 No |
Where do we use decode and case statements?
how do we code triggers , store procedure , Performance tuning and indexing in a Java Project? Pls kindly get me the perfect answer with the code for each....thank you in advance............pls any body kindly help me soon as possible....
What is ceil and floor in oracle?
How to handle a single quote in oracle sql?
Explain coalesce function?
How to initialize variables with default values?
can you explain performance tunning in oracle(sql,PL/SQL)
what is difference between DBMS and RDBMS?
What is the Tune Query
How to export data with a field delimiter?
I'm doing my final year and i ve planned to do an oracle certification , is this the rit tim nd wat's the future scope??
What is the quickest way to export a table to a flat file?