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!

Mat View with left join and case statement

Johnny BSep 12 2023

Hi all,

I was looking into this post:

https://stackoverflow.com/questions/1312980/oracle-materialized-view-not-working-when-using-left-join

I have the same issue using mat view with left join. My problem is that my query has CASE STATEMENTS in the select, is there a way around that?

Can I use a function? The function can take care the case statement.

Thanks in advanced.

Johnny

This post has been answered by Solomon Yakobson on Sep 12 2023

Jump to Answer

Added on Sep 12 2023

10 comments

412 views