Data Type NUMBER length 38 Or 22....???
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Data Type NUMBER length 38 Or 22....???

  1. #1
    Join Date
    Jul 2000
    Location
    Pune, India
    Posts
    80

    Data Type NUMBER length 38 Or 22....???

    Hi,

    We are using Oracle 8.1.6 on Windows 2000. Recently I came across Data type NUMBER difference. In User_Tab_Columns If data type is NUMBER it shows data length 22, Data Precision Null and Data Scale 0. Where as some places it shows data length 22, Data Precision 38 and Data Scale 0. Which is correct behavior?

    Normally while creating table we don't define precision, scale value. Our standard script is as follows....

    Create table Test (
    No NUMBER,
    TestId SmallInt,
    Amount Integer)

    Oracle treats rest ANSI numeric data types as number. Why it shows 22 in data length?

    Please Help.

    Thanks & Regards,

    Shailesh

  2. #2
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938

    Re: Data Type NUMBER length 38 Or 22....???

    22 is the maximum number of bytes that canbe stored.

    Read Metalink Note:105769.1: DATA_LENGTH of View DBA_TAB_COLUMNS Always Shows Value of 22.
    Oracle Certified Master
    Oracle Certified Professional 6i,8i,9i,10g,11g,12c
    email: ocp_9i@yahoo.com

  3. #3
    Join Date
    Jul 2000
    Location
    Pune, India
    Posts
    80

    Re: Re: Data Type NUMBER length 38 Or 22....???

    Originally posted by julian
    22 is the maximum number of bytes that canbe stored.

    Read Metalink Note:105769.1: DATA_LENGTH of View DBA_TAB_COLUMNS Always Shows Value of 22.
    Thank you very much Julian.

    Regards,

    Shailesh

Posting Permissions

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


Click Here to Expand Forum to Full Width