How can an Oracle NUMBER have a Scale larger than the Precision?

Posted by aiGuru on Stack Overflow See other posts from Stack Overflow or by aiGuru
Published on 2010-03-18T21:30:29Z Indexed on 2010/03/18 21:31 UTC
Read the original article Hit count: 320

Filed under:

Oracle

|

scale

|

precision

The documentation states: "Precision can range from 1 to 38. Scale can range from -84 to 127".

How can the scale be larger than the precision? For example I can't create a column with the datatype NUMBER(10, 100). Shouldn't the Scale range from -38 to 38?

© Stack Overflow or respective owner

Related posts about Oracle

E-Business Suite Technology Sessions at OpenWorld 2012

as seen on Oracle Blogs - Search for 'Oracle Blogs'
Oracle OpenWorld 2012 is almost here! We're looking forward to updating you on our products, strategy, and roadmaps. This year, the E-Business Suite Applications Technology Group (ATG) will participate in 25 speaker sessions, two Meet the Experts round-table discussions, five demoground booths and… >>> More
26 Days: Countdown to Oracle OpenWorld 2012

as seen on Oracle Blogs - Search for 'Oracle Blogs'
Welcome to our countdown to Oracle OpenWorld! Oracle OpenWorld 2012 is just around the corner. In less than 26 days, San Francisco will be invaded by an expected 50,000 people from all over the world. Here on the Oracle WebCenter team, we’ve all been working to help make the experience a great… >>> More
OTN ???? ?????? ???????

as seen on Oracle Blogs - Search for 'Oracle Blogs'
Database ?? Database ??????? Database ?????????? Java WebLogic Server/????????·???? SOA/BPM/????? ???????/???? ID??/?????? ?????EPM/BI EPM/BI ??????? EPM/BI ???? OS/??? ???? ????? MySQL Database ?? ???? ?? ????????? ??? ?? ORACLE MASTER… >>> More
SOA PARTNER COMMUNITY NEWSLETTER JULY 2012

as seen on Oracle Blogs - Search for 'Oracle Blogs'
SOA PARTNER COMMUNITY NEWSLETTER JULY 2012 Dear SOA partner community member To provide our community members the best of our knowledge, we want your feedback on our SOA Partner community. Thus we are organizing SOA Partner Community Survey 2012. We… >>> More
Oracle ADF Coverage at OOW

as seen on Oracle Blogs - Search for 'Oracle Blogs'
Below is the schedule for all ADF related sessions at a glance. Note the Meet and greet session added for Wednesday Octiber 3rd from 4.30 pm to 5:30. Oracle ADF and Fusion Development General Session Mon 1 Oct,… >>> More

Related posts about scale

how to make a function recursive

as seen on Stack Overflow - Search for 'Stack Overflow'
i have this huge function and i am wondering how to make it recursive. i have the base case which should never come true, so it should always go to else and keep calling itself with the variable t increases. any help would be great thanks def draw(x, y, t, planets): if 'Satellites' in planets["Moon"]: … >>> More
iteration in latex

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, I would like to use some iteration control flow to simplify the following latex code \begin{sidewaystable} \caption{A glance of images} \centering \begin{tabular}{| c ||c| c| c |c| c|| c |c| c|c|c| } \hline \backslashbox{Theme}{Class} &\multicolumn{5}{|c|}{Class… >>> More
Windows Azure: General Availability of Web Sites + Mobile Services, New AutoScale + Alerts Support, No Credit Card Needed for MSDN

as seen on ASP.net Weblogs - Search for 'ASP.net Weblogs'
This morning we released a major set of updates to Windows Azure. These updates included: Web Sites: General Availability Release of Windows Azure Web Sites with SLA Mobile Services: General Availability Release of Windows Azure Mobile Services with SLA Auto-Scale: New automatic scaling… >>> More
SCALE 8x: Color management for everyone

as seen on Internet.com - Search for 'Internet.com'
<b>LWN.net:</b> "Color management is sometimes unfairly characterized as a topic of interest only to print shops and video editors, but as Cruz explained at the top of his talk, anyone who shares digital content wants it to look correct, and everyone who uses more than one device knows… >>> More
SCALE 8x: Free software legal issues

as seen on Internet.com - Search for 'Internet.com'
<b>LWN.net:</b> "But in reality the FLOSS ecosystem relies on a complex legal framework in order to run smoothly and to stand up to proprietary software competition: the various software licenses, contribution agreements, copyright and other "intellectual property" law." >>> More