Results 1 to 2 of 2

Thread: using Decimals

  1. #1
    Join Date
    Feb 2009
    Posts
    1

    Unanswered: using Decimals

    Create table numbers( Model_ID NUMBER CONSTRAINT pk_numbers PRIMARY KEY,
    Width NUMBER(5));


    after inputting data into this table i am unable to see the decimal, is there another data type command???

  2. #2
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1
    NUMBER(5) is equivalent to NUMBER(5,0), which is 5 digits with no decimal places. For 2 decimal places you would use something like NUMBER(7,2).

    See the manual.

Posting Permissions

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