Oracle Database Discussions

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!

Equivalent to SYSDATE in materialized views

sgalaxyJun 20 2006 — edited Jun 21 2006

Hi everybody,
I need to make some materialized views with query rewrite enabled.

However , some of them have the word sysdate which is not applicable to query rewritable mv's.

Is there any equivalent to sysdate ..?????

Thanks , beforehand
Simon

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 19 2006

Added on Jun 20 2006

#general-database-discussions

1 comment

406 views