Oracle別名（alias）是一種為表、列或者子查詢分配臨時名稱的方法，它可以簡化復雜查詢中的表達式和提高可讀性
SELECT emp_first_name AS first_name, emp_last_name AS last_name
FROM employees;
SELECT e.employee_id, d.department_id
FROM employees e, departments d
WHERE e.department_id = d.department_id;
SELECT employee_id, salary, salary * 12 AS annual_salary
FROM employees;
SELECT *
FROM (SELECT employee_id, salary FROM employees) AS subquery
WHERE subquery.salary > 5000;
SELECT e.employee_id, e.first_name, d.department_name
FROM employees e
JOIN departments d ON e.department_id = d.department_id;
SELECT department_id, COUNT(*) AS num_employees
FROM employees
GROUP BY department_id;
總之，在復雜查詢中使用別名可以提高查詢的可讀性和易于理解，同時也有助于簡化查詢語句。
