Question: Exercise 8 Declare a cursor dept_cursor to retrieve department_id and department name for those departments with department_id less than 100. Order by department_id. Open dept_cursor
Exercise 8 Declare a cursor dept_cursor to retrieve department_id and department name for those departments with department_id less than 100. Order by department_id. Open dept_cursor and use a simple loop to fetch values into the variables declared. Exercise 9: Based on Exercise 8, display the department number and department name. Use the appropriate cursor attribute to exit the loop
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
