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 |
I have a table that log salary-increase-process have fields: autoid, old_salary, acctno and table EMP: acctno, name, salary I want to list count increase-salary of employees, each have old_salary, new_salary. Help me with SELECT statement, please!
various types of joins
How to use values from other tables in update statements using oracle?
i have a question here... As of my knowledge, when we apply an index (b-tree)on a column, internally it arranges the data in b-tree format and do the fetching process correspondingly... and my quetion is... How a bit-map index arranges the data internally when applied on a column?IS it in b-tree format or whatelse?
What is oracle database client?
What is a dynamic performance view in oracle?
State the difference along with examples between Oracle 9i, Oracle 10g and Oracle 11i.
What is user managed backup in Oracle?
Tab A A B ------ 1 A 2 B 3 C Tab B A B ----- 4 D 5 E 6 F Generate the value into B table from A table. Only table A has the value. Write the SQL query to get B table value.
How to check your oracle database 10g xe installation?
what is the scripts in data base?
How to write text literals in oracle?