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