Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to put a materialized view for every 5 mins refresh

Gayathri VenugopalSep 21 2016 — edited Sep 21 2016

This is the code:

create materialized view vw_sof as

select DISTINCT B.S_ID , A.RENEWAL_DATE,B.X_SCF,

         case when trunc(B.DFLT_END_DT- B.DFLT_START_DT) + 1 < = 365 THEN 365 

         ELSE trunc(B.DFLT_END_DT- B.DFLT_START_DT)   

          END SCF

     from VW_RENEWAL_DATE A ,TABLE_CONTRACT B

      WHERE B.S_ID = A.S_ID(+)

     

what changes has to be made in this code ,so that i refreshes for every 5 mins

This post has been answered by AndrewSayer on Sep 21 2016
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 19 2016
Added on Sep 21 2016
4 comments
1,093 views