Working On Oracle Sample Database Tables ( Departments and Employees) 1- Suppose we want to select employees Names in each department Query : SELECT departments.department_id, departments.department_name, employees.first_name || ' ' || employees.last_name FROM employees JOIN departments ON departments.department_id = employees.department_id ORDER BY departments.department_id; Results : 10 Administration Jennifer Whalen 20 Marketing Michael Hartstein 20 Marketing Pat Fay 30 Purchasing Den Raphaely 30 Purchasing Karen Colmenares 30 Purchasing Alexander Khoo 30 Purchasing Shelli Baida 30 Purchasing Sigal Tobias 30 Purchasing Guy Himuro 40 Human Resources Susan Mavris 50 Shipping Donald OConnell ................................................................. we want to know how we can make the results like : 10 Administration Jennifer Whalen 20 Marketing Michael Hartstein, Pat Fay 30 Purchasing Alexander Khoo, Den Raphaely, Guy Himuro, Karen Colmenares, Shelli Baid...