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!

Materialized View

yxes2013Mar 4 2013 — edited Mar 5 2013

Hi All,

10.2.0.4

I am creating a materialized view with query rewrite, but it failed on a column conversion. How do I make work around for this column please....

 TO_CHAR(DECODE (SALARY, 0, 0, TRUNC (COMM / INCENT * 100, 2) ),'FM999.00') turnout,
                      *
ERROR at line 7:
ORA-30357: this PL/SQL function cannot be supported for query rewrite

I thank you all,

zxy

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 2 2013

Added on Mar 4 2013

#general-database-discussions

10 comments

560 views