Interested to Buy Any Domain ? << Click Here >> for more details...
In which dictionary table or view would you look to
determine at which time a snapshot or MVIEW last
successfully refreshed?
- 1 Answers
- 3537 Views
- I also Faced
- E-Mail Answers
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 |
difference between bind variable and variable
What is oracle latest version?
Who developed oracle & when?
How do I find the database name in oracle?
HI Friends Myself Manoj,i am from bengaluru.i have 1 yr of exp in PLSQL but not upto the mark..now attending interviews but m not able to clear even 1 round..i have attended 3 interviews till today.purpose of writing this query is,i want to know the intreview topics that interviewer going to ask frequently,mainly SCENARIO based questions.IF anybody have any PLSQL projects please give it to me,it will helps me alot.Thanks for your patience.
1.What is inline function in oracle and its purpose? 2.What is the equivalent operator for "different from pattern" in oracle? 3. If you define a variable in oracle, how it will be available? [a. Until database shut down b. Until table deleted c. until session get expired]
What is Oracle table?
4. Display the order number and client number from the ORDER table. Output the result in the format. Client <clientno> ordered <orderno>
What is blob datatype?
How to create additional tablespaces for an new database?
How can I get column names from a table in oracle?
What are privileges and grants?
Oracle General 
