This content has been marked as final. Show 4 replies
Below is the sample query extracted from the main query.
this is a view query only . I need to make Materialized view from this. Can you please suggest any alternate way to achieve the same.
MAKE_REF(TASK_DTLS_v, DECODE(BTV.ROWID_TASK,NULL,'°',BTV.ROWID_TASK) ) TASK,
MAKE_REF(PROJEKTTYP_v, DECODE(P.ROWIDPROJECT,NULL,'°',P.ROWIDPROJECT) ) PROJECT
WHERE BT.PSYBAUTEILID = P.PSYBAUTEILID
AND BTV.PSYBAUTEILVERSIONID = BT.PSYBAUTEILVERSIONID ;