How to implement (next_day(sysdate,'SAT')-6) in Incorta Materialized View (MV) Query?
Dan Brock Anurag Malik
Hope it will work for you.
From this syntax you can add or minus the days, and use the "$ Variable" functions in case if you want to manipulate weeks or years .
Let me know its worked for you or not?
© Incorta, Inc. All Rights Reserved.
We are happy to announce Incorta 4.8 !!!