view materialized
by williams paillan
santiago de chile
williams.paillan@udp.cl

////////////////////////////


1.- This is a view's example materialized, that an hour refreshes  itself automatically each

*********
DROP MATERIALIZED VIEW MM2;
CREATE MATERIALIZED VIEW MM2
REFRESH COMPLETE with rowid
START WITH sysdate
NEXT sysdate + 1/24
AS Select bank_ont, st_date  
    from dbr_bank_official a, 
         dbr_bank_none b
   where a.bin = b.bin;
**********

2.- Another possibility is to refresh the view, road procedures, or each you see that you get busy 
***********

DROP MATERIALIZED VIEW MM2;
CREATE materialized VIEW MM2
AS SELECT *
FROM tabla_master;
****
procedure pppp
begin
   dbms_mview.refresh('owner.MM2',null,null,true,false,1,0,0,true);
   or
   dbms_mview.refresh('owner.MM2');
 --- Another Declaración or you sentence pl-sql
end pppp;
/
*************

3.- 
SQL--EJEMPLO
--------------
SQL> DESC TABLE_MASTER;
 Name                                      Null?    Type
 ----------------------------------------- -------- -------------------
 ID_SEXO                                   NOT NULL CHAR(1)
 N_SEXO                                    NOT NULL VARCHAR2(10)
 TRATAMIENTO                                        CHAR(1)
 TITULO                                             VARCHAR2(5)
 FEC_ULT_ACTUALIZACION                              DATE
 COMENT                                             VARCHAR2(2000)
 ID_USUARIO                                         VARCHAR2(40)

SQL> 
-------------------------

Then, in the where of the select of the view materialized, the records would be  branded to materialize


DROP MATERIALIZED VIEW MM2;
CREATE materialized VIEW MM2
AS SELECT *
FROM tabla_master
where FEC_ULT_ACTUALIZACION > ADD_MONTHS(SYSDATE, -4);

-------------------
Add_months (date, months ), the fact that a date, to count of today, returns with - 4 months