BIGINT Datatype

[praveenmittal]

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

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

9.2233720368547 8E18.

Please provide the solution.

Thanks

Praveen

[debasisdas]

Use number only ,without specifying the P & S.

[amitpatel66]

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

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

9.2233720368547 8E18.

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.

[debasisdas]

Are you facing any data loss because of that format.
I don't think there will be any. so what is the problem.

[praveenmittal]

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