When multiple tables are involved in a query, using table aliases helps to make it more understandable and keeps it short.
Noncompliant code example
BEGIN
SELECT
name,
firstname,
location
INTO employeesArray
FROM employee -- Noncompliant - should be aliased
INNER JOIN department -- Noncompliant - should be aliased
ON employee.DepartmentID = department.ID;
END;
/
Compliant solution
BEGIN
SELECT
empl.name,
empl.firstname,
dpt.location
INTO employeesArray
FROM employee empl
INNER JOIN department dpt
ON empl.DepartmentID = dpt.ID;
END;
/
