SQL Daily (@sqldaily) 's Twitter Profile
SQL Daily

@sqldaily

Daily Oracle SQL tips from the Oracle Developer Advocates for SQL

ID: 3001841930

linkhttp://blogs.oracle.com/sql calendar_today29-01-2015 17:45:15

2,2K Tweet

25,25K Takipçi

4 Takip Edilen

SQL Daily (@sqldaily) 's Twitter Profile Photo
SQL Daily
@sqldaily

3 months ago

Run bit AND, OR, and XOR operations across numbers in Oracle #SQL using BIT_AND_AGG BIT_AND_AND BIT_AND_OR functions from 21c These convert numbers to binary, then do bitwise comparisons across rows 3 => 011 5 => 101 3 AND 5 => 001 => 1 3 XOR 5 => 110 => 6 3 OR 5 => 111 => 7

Run bit AND, OR, and XOR operations across numbers in Oracle #SQL using BIT_AND_AGG BIT_AND_AND BIT_AND_OR functions from 21c These convert numbers to binary, then do bitwise comparisons across rows 3 => 011 5 => 101 3 AND 5 => 001 => 1 3 XOR 5 => 110 => 6 3 OR 5 => 111 => 7