BIT_OR()函數(shù)返回表達式中所有的按位或。按位或函數(shù)的基本前提是,它返回0,如果相應的位匹配,1,如果他們不這樣做。該函數(shù)返回一個64位的整數(shù),如果沒有匹配的行,則返回0。下面的例子執(zhí)行上的CARS表,由MAKER分組的PRICE列:
SQL> SELECT
MAKER, BIT_OR(PRICE) BITS
FROM CARS GROUP BY MAKER
+---------------------------------------------------------+
|MAKER BITS |
+---------------------------------------------------------+
|CHRYSLER 62293 |
|FORD 16127 |
|HONDA 32766 |
+---------------------------------------------------------+
1 row in set (0.00 sec)