Default size of number datatype

I would like to know what is the default size of number
datatype in Oracle  if the size is not specified while creating the table .

Eg:
Create table emp
(empno number,
name varchar(20));

Thanks
sumans1Asked:
Who is Participating?
 
davidgornshteinConnect With a Mentor Commented:

Hi,
 If you are not defining restrictions on number
 size, you can insert every number within oracle
 internal definitons restrictions.

 It's from the oracle manual about system defined  
 restrictions:

 The NUMBER datatype stores zero,
 positive, and negative fixed and
 floating-point numbers with magnitudes
 between 1.0 x 10 -130 and 9.9...9 x 10 125
 (38 nines followed by 88 zeroes)
 with 38 digits of precision.

 This means, that you can store every number.

 However, you should understand, that precision and
 scale in NUMBER(precision ,scale) is restrictions
 on number.

 Look at internal representation of number:

 Number defined in oracle as variable length sequence
 where first byte is exponent + sign (msb) and
 all other bytes are mantissa represented in excess 100
 and last byte is 0x66 for negatives.

example:
  02 c1 33   - this means 2 -length, c1 - 128 - 65 =0
               0x33 = 51  
  (51 - 1) * 100^0 = 50

Regards.

 
0
 
myerpzCommented:
The default size is 38
0
 
DanRollinsCommented:
Hi sumans1,
It appears that you have forgotten this question. I will ask Community Support to close it unless you finalize it within 7 days. If there is no objection or further activity, I will suggest to:

    Accept davidgornshtein's answer.

sumans1, if you think your question was not answered at all, you can post a new comment here.  Community Support moderators will followup.

Please do not accept this comment as an answer!

EXPERTS: Your input and closing recommendations are REQUESTED.
==========
sumans1 -- EE database cleanup volunteer
0
 
DanRollinsCommented:
Recommended disposition:

    Accept davidgornshtein's comment(s) as an answer.

DanRollins -- EE database cleanup volunteer
0
 
MoondancerCommented:
Thanks for your help here, Dan.
Finalized.
Moondancer - EE Moderator
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.