469,310 Members | 2,427 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,310 developers. It's quick & easy.

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 31724
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

Post your reply

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

Similar topics

3 posts views Thread by KK | last post: by
10 posts views Thread by MK | last post: by
1 post views Thread by MK | last post: by
5 posts views Thread by Rafał Maj Raf256 | last post: by
reply views Thread by Dan Ruthers | last post: by
2 posts views Thread by Dave Bazell | last post: by
reply views Thread by zhoujie | last post: by
1 post views Thread by Geralt96 | last post: by
reply views Thread by harlem98 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.