Confused about the Number datatype

Ranch Hand

Posts: 31

posted 16 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

I have 2 tables and both having "PK" column.

In 1 table, PK is defined as NUMBER(38)
And in second table, PK is defined as only NUMBER.

What is difference in that?

Mohnish

Sona Patel

Ranch Hand

Posts: 75

posted 16 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

NUMBER(p)
is a fixed point number with precision p and scale 0.

NUMBER
is a floating point number with precision 38. Note that a scale
value is not applicable for floating point numbers.

Refer below link
http://www4.utc.fr/~nf17/DOCS/complement/sqlplus-ref/NUMBER-DATATYPE.html

Would you turn that thing down? I'm controlling a mind here! Look ... look at the tiny ad ...

Clean our rivers and oceans from home

https://www.kickstarter.com/projects/paulwheaton/willow-feeders