Skip to Main Content
Forums

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!

Find Maximum Possible Value for a Column?

johnnysubwayApr 13 2007 — edited Apr 27 2007
Hi Oracle Oracles. ;)

I have a question that seems easy at first, but is not what it sounds like. If I have a column, say NUMBER(10), how could I find the maximum possible value for that column? So not the maximum value stored in the table for that column, as MAX(Column) would return. I'm trying to avoid hardcoding something like 9999999999 in case column sizes change.

Thanks!

- Dave
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 25 2007
Added on Apr 13 2007
26 comments
4,199 views