ORACLE MVIEW "using" syntax

Viewed 23

Can somebody help me to understand the syntax of "using" in oracle martialized view in below code? I have given the mview code below.

CREATE MATERIALIZED VIEW "mymview" ("fld1", "fld2", "fld3", "fld4") 

USING ( mymview, (10, 'xyzdb', 2, 0, 0, "xyzdb_user", "table1", '2022-08-23 02:16:39', 33024, 234165, '2022-08-23 02:16:39', '', 0, 15128024780689, 0, NULL, 1, "xyzdb_user", "table2", '2022-08-23 02:16:40', 33024, 323356, '2022-08-23 02:16:40', '', 0, 15128024780689, 0, NULL), 
2105409, 10, ('1950-01-01 12:00:00', 15, 0, 0, 15128024780689, 0, 2097216, 0, 2, NULL, NULL)) 

REFRESH FORCE AS (SELECT
    /*+ PARALLEL(SERVICE_HOLD 8) PARALLEL(EVT 8) */
    SERVICE_HOLD.fld1,
    SERVICE_HOLD.fld2,
    EVT.fld3,
    EVT.fld4
  FROM xyzdb_user.table1 SERVICE_HOLD,
    xyzdb_user.table2 EVT
  WHERE SERVICE_HOLD.fld       =EVT.fld    
  );

Thanks

0 Answers
Related