Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2004
    Posts
    74

    Unanswered: Number Precision in Materialized View

    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

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    SELECT TRUNC(numeric_column,5) ...
    SELECT CAST (numeric column AS NUMBER(5)) ...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •