Advertisement
Guest User

Untitled

a guest
Jun 26th, 2019
99
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.20 KB | None | 0 0
  1. EMPLOYEE_ID EMPLOYEE_NAME EMPLOYEE_CAR EMPLOYEE_AGE
  2. 1 Mike Camry 35
  3. 2 Mark Civic 33
  4. 3 Helen Beetle 25
  5.  
  6. EMPLOYEE_FEEDBACK_ID EMPLOYEE_ID FEEDBACK_COMMENT_TX
  7. 1 1 Very Good
  8. 2 1 Average
  9. 3 1 Phenomenal
  10. 4 2 Okay
  11. 5 2 NO Comment
  12. 6 3 Excellent
  13. 7 3 Hilarious
  14.  
  15. EMPLOYEE_NAME EMPLOYEE_CAR EMPLOYEE_AGE Comments
  16. Mike Camry 35 Very Good Average Phenomenal
  17. Mark Civic 33 Okay No Comment
  18. Helen Beetle 25 Excellent Hilarious
  19.  
  20. select employee_name
  21. , employee_car
  22. , employee_age
  23. , listagg(feedback_comment_Tx, ' ') within group (order by e.employee_id)
  24. from employee e
  25. join employee_feedback ef ON ef.employee_id = e.employee_id;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement