-
can some one please tell me the differences between these 3 numeric data types?
number(6)
number
number(6,4)
-
number(6) = Rows can only be between 0 - 100000
number = unlimited rows without decimals
number(6,4) = up to 100000 with four decimals but it is much better as number(6,2)
I hope this helps you.
C.K.
Apps DBA
-
Originally posted by cekeke
number(6,4) = up to 100000 with four decimals but it is much better as number(6,2)
I hope this helps you.
C.K.
Apps DBA [/B]
:-) For how long time have you been using Oracle?
Because from your answer above, somebody could get the impression that you can store 999999 into a number(6,4) field.
Oracle Certified Master
Oracle Certified Professional 6i,8i,9i,10g,11g,12c
email: ocp_9i@yahoo.com
-
:-) For how long time have you been using Oracle?
I don't think you have to insult him by saying this. he's trying to help, if he's wrong just correct him. Besides, you've had some mistakes here yourself.
You think I'm going to have an affair with you? --Stanley Kowalski
-
Originally posted by julian
from your answer above, somebody could get the impression that you can store 999999 into a number(6,4) field.
Hardly. One should have a wild immagination to get the impression that 999999 can be stored into a number that was defined as "can stored values up to 100000 " (as defined by cekeke).
Jurij Modic
ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?
-
number(6) = Rows can only be between 0 - 100000
number = unlimited rows without decimals
number(6,4) = up to 100000 with four decimals but it is much better as number(6,2)
---------------------------------------------------------
number(6) = maximum length of number you can enter is upto 999999.
number with any limit defaults to maxium value which is upto 38 precisions.
You should test this out by creating a test table with this datatype instead of waiting response from users on this site.
Also, goto http://otn.oracle.com and download Oracle8i concepts pdf for more information on Oracle datatypes.
Create table table1
( col1 number(6),
col2 number,
col3 number(6,4));
and then insert maximum values using simple insert statement. I am sure you can do this.. Let me know if you need further explanation on this...
Cheers!!!
Mohammad Zahid
Software Developer
Database Management Applications.
Vancouver, Canada
E-mail: mzahid@shaw.ca
-
Originally posted by jmodic
Originally posted by julian
from your answer above, somebody could get the impression that you can store 999999 into a number(6,4) field.
Hardly. One should have a wild immagination to get the impression that 999999 can be stored into a number that was defined as "can stored values up to 100000 " (as defined by cekeke).
:-) 99999 OK?
Oracle Certified Master
Oracle Certified Professional 6i,8i,9i,10g,11g,12c
email: ocp_9i@yahoo.com
-
Originally posted by TheSlob
:-) For how long time have you been using Oracle?
I don't think you have to insult him by saying this. he's trying to help, if he's wrong just correct him. Besides, you've had some mistakes here yourself.
Borrow some sense of humour ;-)
Oracle Certified Master
Oracle Certified Professional 6i,8i,9i,10g,11g,12c
email: ocp_9i@yahoo.com
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|