473,385 Members | 2,028 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,385 software developers and data experts.

BIGINT Datatype

I need to create a column which can hold bigint datatype. Sample of the value is 9223372036854775803.

I tried creating a column using the 'number(20)' datatype, but it stores the value in the following format:

9.22337203685478E18.

Please provide the solution.

Thanks

Praveen
Sep 12 '07 #1
4 32606
debasisdas
8,127 Expert 4TB
Use number only ,without specifying the P & S.
Sep 12 '07 #2
amitpatel66
2,367 Expert 2GB
I need to create a column which can hold bigint datatype. Sample of the value is 9223372036854775803.

I tried creating a column using the 'number(20)' datatype, but it stores the value in the following format:

9.22337203685478E18.

Please provide the solution.

Thanks

Praveen
All the datatypes INT, NUMBER, SMALLINT stores the value in Exponentiation format.

You can use LONG for such kind of data if that is fine for your requirement. But when you perform any mathematical operation on LONG column, then it will be internally converted to NUMBER and will get displayed as Exponentiation form only.
Sep 12 '07 #3
debasisdas
8,127 Expert 4TB
Are you facing any data loss because of that format.
I don't think there will be any. so what is the problem.
Sep 12 '07 #4
Are you facing any data loss because of that format.
I don't think there will be any. so what is the problem.
Thanks for the reply.

The Long datatype is working fine. It stores the value has it is and doesnt convert into Exponential form.

With Number datatype, there was no loss of information but the value was getting converted into Exponential form.

I just need to check, any specific datatype like bigint is available in Oracle or not as MSSQL provides (hope so).

Regards

Praveen
Sep 13 '07 #5

Sign in to post your reply or Sign up for a free account.

Similar topics

3
by: KK | last post by:
Hi, im working on this bigInt class. Need help writing algorithm for the operator*, andy help will be appreciated. Thanks in advance bigInt.h...
10
by: MK | last post by:
Hello, I use BigInt lib from: http://www.codeguru.com/Cpp/data/data-misc/values/article.php/c4563/ It doesn't work properly. I describe my problem:...
1
by: MK | last post by:
I need div two big int. I use this lib: https://sourceforge.net/projects/cpp-bigint/ I create simple project and include two file bigint.h and bigint.cpp (Precompiled headers is not using) When...
5
by: Rafał Maj Raf256 | last post by:
Hi, is there some small project that proviedes bigint, best as a C++ class, or just as set of struct/functions (C-style)? Something like GMP and it's bigint, but I want to have it just in one...
2
by: Jon | last post by:
Since there is no native support for 64bit integers in dbExpress, it is not trivial to fetch a BIGINT from SQL 2k. If it is possible, how can a BIGINT be fetched using TParam or TField? Any...
0
by: Dan Ruthers | last post by:
Hi, I have read in this list and elsewhere the problem with indexes and big int. Still, I have an index that is used or not, depending of the parameter value used in the query. I am using...
2
by: Dave Bazell | last post by:
I was using Math::BigInt and found that postive integers have a leading plus sign: +12345678900000 Is there a way to supress this? Thanks, Dave
1
by: Praveen | last post by:
HI, I have a table with IDENTITY column with the datatype as INTEGER. Now this table record count is almost reaching its limt. that is total record count is almost near to 2^31-1. It will reach...
0
by: SQLGuy | last post by:
My company had a partitioned view across 5 SQL 2000 and 2005 clusters, with 1.9B rows of data, with the key using datatype of int. At this point, we need to convert everything to bigint very soon. We...
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.