SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

database design: field to store percent value

WestDraytonJan 20 2010 — edited Jan 20 2010

I need to create a table T that holds field P which is going to store percentage values.

1. Should database store in field P value "3.5" or "0.035" if user enters on web page string "3,5%"? Which is wiser design- to store as values in range 0..1, or in range 0...100 for percentages?

2. How does enterprise products solve this? For example, "Oracle E-Business Suite" is there any field that holds percentage value? How it holds?

Thanks.

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 17 2010

Added on Jan 20 2010

10 comments

5,060 views