<div>
&quot;what is the largest bit number i can store&quot;<br />
<br />
the largest integer is number(38,0) &nbsp; meaning 38 decimal digits<br />
which translates to 127 bits but only 126 of which are fully useable.
</div>


"what is the largest bit number i can store"

the largest integer is number(38,0)   meaning 38 decimal digits
which translates to 127 bits but only 126 of which are fully useable.

<div>
<div class="content wysiwyg-content">
I want to use a bitmask to hold over 2000 binary states. &nbsp;So I'm reckoning that I'm going to need a field that is at least 2000 bits long (i.e. 2^2000 or 10^602) . &nbsp;Inbuilt numbers in oracle have a scale of -84 to +127, so thats not going to be big enough, I think...<br />
<br />
Because one of the cool things about bitmasks is the ability to do quick bitwise compairsons to check for on/off, I was hoping to have the db treat this bitmask as a number. &nbsp;Of course I could be missing something...<br />
<br />
Other alternatives I though of would be to split the single bitmask into several smaller ones - in which case this question reverts to - &quot;what is the largest bit number i can store&quot;<br />
<br />
I'm using Oracle 11g...Thanks!....Paul
</div>
</div>


I want to use a bitmask to hold over 2000 binary states.  So I'm reckoning that I'm going to need a field that is at least 2000 bits long (i.e. 2^2000 or 10^602) .  Inbuilt numbers in oracle have a scale of -84 to +127, so thats not going to be big enough, I think...

Because one of the cool things about bitmasks is the ability to do quick bitwise compairsons to check for on/off, I was hoping to have the db treat this bitmask as a number.  Of course I could be missing something...

Other alternatives I though of would be to split the single bitmask into several smaller ones - in which case this question reverts to - "what is the largest bit number i can store"

I'm using Oracle 11g...Thanks!....Paul

What is the best way to store a bitmask with over 2,000 bits (10^600)

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.