/* Operators */
/* Addition, Subtraction, Multiplication and Division
# Addition : +
# Subtraction : -
# Multiplication : *
# Division : /
*/
/* Concatenation
# || concatenates two 'strings or numeric data sets'
*/
/* Test */
SELECT 1010 || 1111 FROM dual; -- 10101111
SELECT 'Concatenates ' || 'Me!' FROM dual; -- Concatenates Me!
SELECT
employee_id || '-' || emp_name
AS emplyee_info
FROM employees
WHERE ROWNUM < 5
;
/* Relational Operators
Left Operand Right Operand
# > L is greater than R
# < L is less than R
# >= L is greater than or equal to R
# <= L is less than or equal to R
# = L is equal to R
# <> L is NOT equal to R
# != L is NOT equal to R
# ^= L is NOT equal to R
*/
/* Set Operators (Chapter 5)
# UNION
# UNION ALL
# INTERSECT
# MINUS
*/
/* Hierarchical Operators (Chapter 7)
# PRIOR
# CONNECT_BY_ROOT
*/
On-orbit