[Oracle] SELECT문 LIKE, NOT, IS NOT NULL 연산자
2020. 8. 9.
NOT 연산자 -> NOT, , ^=, != 연산자를 통해 부정을 나타낸다. ->SELECT department_id, department_name FROM departments WHERE NOT department_id = 10; ->SELECT department_id, department_name FROM departments WHERE department_id 10; ->SELECT department_id, department_name FROM departments WHERE department_id ^= 10; ->SELECT department_id, department_name FROM departments WHERE department_id != 10; IS NOT NULL 연산자 -> ..
