Use a cursor to retrieve the location number and the cityfrom the locations table. Pass the location number to anothercursor to retrieve from the emp_details_view the last_namejob_title and salary for that employees that work at thatlocation.
Your email address will not be published. Required fields are marked *
Comment *
Name *
Email *
Website
Save my name, email, and website in this browser for the next time I comment.
Δ