title: select oracle union and union all did not display the department name name
body: <p>I have used union all to get 2 data from 2 tables but it did not display the department name</p>
  <pre><code>select employees.department_id,employees.last_name   
    from employees
  union all
  select departments.department_id ,departments.department_name   
    from departments; 
  </code></pre>