Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Database > Oracle
| Search | Today's Posts | Mark Forums Read
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
  #1 (permalink)  
Old March 9th, 2007, 04:34 PM
Authorized User
 
Join Date: Jan 2007
Location: , , .
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

MAXOOD!

Life is an endless journey towards perfection
__________________
MAXOOD!

Life is an endless journey towards perfection
  #2 (permalink)  
Old April 9th, 2009, 04:56 PM
Authorized User
 
Join Date: Mar 2007
Location: New Delhi, Delhi, India.
Posts: 10
Thanks: 0
Thanked 0 Times in 0 Posts
Smile

hi,
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
__________________
Akhil


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.