位运算符简单使用

#逻辑运算符 OR || AND && NOT  !  XOR
#  OR   AND
SELECT last_name,salary,department_id
FROM employees
#WHERE department_id =10 OR department_id =20;
#WHERE department_id =10 AND department_id =20;
WHERE department_id =50 AND salary > 6000;

# NOT
SELECT last_name,salary,department_id
FROM employees
#WHERE salary NOT BETWEEN 6000 AND 8000;
WHERE commission_pct IS NOT NULL;

#XOR  追求‘异’
SELECT last_name,salary,department_id
FROM employees
WHERE department_id = 50  XOR salary >6000;
#注意：and  优先级 高于 or

#位运算符 ： & | ^ ~(取反)  >>  <<
SELECT 12 & 5 ,12|5 ,12^5;
FROM DUAL;

SELECT 10 & ~1
FROM DUAL;

#在一定范围内，每向左移动一位，相当于乘2，每向右一位，相当于除2；
SELECT 4<<1,8>>1
FROM DUAL;