-
Which one is better to use ?
Hello all..
I have a dilema here. I am on Oracle 92.
When i create a field in a table that is going to use NUMBER data, which one can i use ?..i read some where that NUMBER datatype can hold both INTEGER and DECIMAL types..is it true ?..
or should i use NUMBER (p,s) for Decimals and just NUMBER for INTEGERS ?...
Thanks
Ron
-
Depends on what numbers you want to store -- if you need decimal places, then specify them.
The precision and scale are simply check constraints that restrict the maximum p & s that the column will store. It makes no difference to how many bytes are used for storage.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|