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!

Number Precision in Materialized View

440175Oct 19 2005 — edited Oct 20 2005

Hey,

I have created several materialized views with multiple fields of data type number. I would like to have those number fields created with max length 5 and precision 0 (no decimal places). I am thinking that each of those database fields will then appear as NUMBER(5,0) in the database, maybe I am wrong on that.

How can I code that into my select statement for which the materialized is created?

Thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 17 2005

Added on Oct 19 2005

4 comments

574 views