Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- EMPLOYEE_ID EMPLOYEE_NAME EMPLOYEE_CAR EMPLOYEE_AGE
- 1 Mike Camry 35
- 2 Mark Civic 33
- 3 Helen Beetle 25
- EMPLOYEE_FEEDBACK_ID EMPLOYEE_ID FEEDBACK_COMMENT_TX
- 1 1 Very Good
- 2 1 Average
- 3 1 Phenomenal
- 4 2 Okay
- 5 2 NO Comment
- 6 3 Excellent
- 7 3 Hilarious
- EMPLOYEE_NAME EMPLOYEE_CAR EMPLOYEE_AGE Comments
- Mike Camry 35 Very Good Average Phenomenal
- Mark Civic 33 Okay No Comment
- Helen Beetle 25 Excellent Hilarious
- select employee_name
- , employee_car
- , employee_age
- , listagg(feedback_comment_Tx, ' ') within group (order by e.employee_id)
- from employee e
- join employee_feedback ef ON ef.employee_id = e.employee_id;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement