Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Database > Oracle
Oracle General Oracle database discussions.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Oracle section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Old March 9th, 2007, 04:34 PM
Authorized User
Join Date: Jan 2007
Posts: 46
Thanks: 2
Thanked 1 Time in 1 Post
Default Scale and Precision in number Data type

What is do we mean by scale and precision in number data type.
What it really means when we declare the following:

nm number(3,6)

Please reply in detail


Life is an endless journey towards perfection

Life is an endless journey towards perfection
Old April 9th, 2009, 04:56 PM
Authorized User
Join Date: Mar 2007
Posts: 10
Thanks: 0
Thanked 0 Times in 0 Posts

in NUMBER u store a decimal value. it can have 2 parameters like num(8,2)

8 tells that it can store upto 8 digits of value (excluding the decimal) and 2 represents number of digits after decimal like 123456.78

Similar Threads
Thread Thread Starter Forum Replies Last Post
Why data-type="number" not working here... akentanaka XSLT 6 July 12th, 2008 07:13 PM
Error Number 13 : Type Mismatch ryoga_7482 BOOK: Expert Access 2007 Programming ISBN 978-0-470-17402-9 2 January 31st, 2008 02:20 AM
casting textbox to sqlserver number data type yoord BOOK: Beginning ASP.NET 1.0 1 October 17th, 2004 06:09 AM
Number precision problem adriant42 Excel VBA 2 June 28th, 2004 01:00 PM
Data Type error but it is the correct type Mitch SQL Server 2000 2 March 19th, 2004 11:31 AM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.