![]() Related Questions 1. can we use DML operations on Dual Table?2. What is difference between View and materialisedView?3. New features in Oracle9i SQL? Read Answers (3) | Asked by : vijaya Latest Answer : After update of the table, the view automatically gets synchronized where as the Materialised view needs an explicit refresh (either Manual or by Oracle) for synchronisation.Another diff is that the rowids of the table and view matches, whereas the MV's ... What is the purpose of Mviews? Outline the difference between refresh types? How to refresh the MView? How to view whether SMON is running or not using batch script?? Latest Answer : ps |grep smon ... Without Using Update Statement on Database how we can Select the Updated values on a Object(Table,View or etc..)? How to count the last transaction number of record in singal table?How to view uncommited transaction / uncommited record?
Sponsored Links
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||