1. Write a script to declare and use a cursor for the following statement:

 

Write a query that displays the names of the customers (show customername in LastName, FirstInitial format). along with the product names that they have purchased.

 

Use a WHILE loop to fetch each row in the result set. Omit the INTO clause to fetch directly to the Results tab. 

Answer rating: 100% (QA)

DECLARE CURSOR CustomerProductCursor IS SELECT CONCATclastname cfirstname AS customername pname AS ... View the full answer