Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Bitwise operators in PL/SQL

Status
Not open for further replies.
Jonathan

Jonathan

Programmer
Mar 19, 1999
116
GB
This seems to me like it should be obvious, but I haven't been able to find out how to do it.

In languages such as VB, VC++, Javascript, it is possible to do "bitwise comparison" on two numbers using AND, OR, etc. For example, 10 AND 2 would equal 2, since:

10 = binary 1010
2 = binary 0010
answer 0010 = 2

Is there an equivalent to this kind of thing in PL/SQL
Jonathan
j.w.george@virginnet.co.uk

Working against: Visual Basic 6, Access 97, Visual Interdev 6, VBScript, JavaScript, Active Server Pages, SQL Server, Oracle 7, XML
 
Sort by date Sort by votes
Found it - its the BITAND function
Jonathan
j.w.george@virginnet.co.uk

Working against: Visual Basic 6, Access 97, Visual Interdev 6, VBScript, JavaScript, Active Server Pages, SQL Server, Oracle 7, XML
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Andrzejek
  • Locked
  • Question
Get part of a string with SQL 1
Replies
2
Views
395
Andrzejek
Andrzejek
Livia8
  • Locked
  • Question
SQL SELECT - where date is null or greater than 2
Replies
9
Views
2K
carp
carp
annie1975
  • Locked
  • Question
sql script in an cron job script failing
Replies
3
Views
173
carp
carp
Livia8
  • Locked
  • Question
SQL script to find number of characters allowed in "Description" column of "AP_INVOIC 2
Replies
5
Views
195
Livia8
Livia8
rk68
  • Locked
  • Question
Data fetch issue thru PL/SQL developer
Replies
4
Views
132
rk68
rk68

Part and Inventory Search

Sponsor

Back
Top