Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

What is the Oracle datatype for BIGINT in SQL server?

694777Jun 4 2009 — edited Jun 4 2009
Hi,

I am converting our database from SQL server to Oracle. Can anyone tell me what is the Oracle datatype corresponds to BIGINT data type in SQL server?

Thanks in advance
Nikhil

Comments

Florian W.
Dear Nikhil!

You may try one of the two types NUMBER or BINARY_INTEGER.

Yours sincerely

Florian W.
701278
Hi nikhilkarun,

MS-SQL Bigint range from -2^63 to 2^63 - 1. You could use Oracle NUMBER(19) to cover the same range with the same precision.
SQL> SELECT CAST (power(2,63) AS NUMBER(19)) FROM dual;

CAST(POWER(2,63)ASNUMBER(19))
-----------------------------
                   9,2234E+18
Regards,

--
Vincent
1 - 2
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jul 2 2009
Added on Jun 4 2009
2 comments
29,939 views