1. CREATE TABLE Employee (
2. E_id INT PRIMARY KEY,
3. E_name VARCHAR(255),
4. Age INT,
5. Salary DECIMAL(10, 2)
6. );
7. INSERT INTO Employee (E_id, E_name, Age, Salary) VALUES (1, 'John Doe',
8. 30, 50000.00);
9. INSERT INTO Employee (E_id, E_name, Age, Salary) VALUES (2, 'Jane Smith',
10. 25, 60000.00);
11. INSERT INTO Employee (E_id, E_name, Age, Salary) VALUES (3, 'Alice
12. Johnson', 35, 70000.00);
13. DELIMITER //
14. CREATE PROCEDURE extract_employee_values()
15. BEGIN
16. DECLARE done BOOLEAN DEFAULT FALSE;
17. DECLARE emp_id INT;
18. DECLARE emp_name VARCHAR(255);
19. DECLARE emp_age INT;
20. DECLARE emp_salary DECIMAL(10, 2);
21. DECLARE cur CURSOR FOR
22. SELECT E_id, E_name, Age, Salary FROM Employee;
23. DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = TRUE;
24. OPEN cur;
25. emp_loop: LOOP
26. FETCH cur INTO emp_id, emp_name, emp_age, emp_salary;
27. IF done THEN
28. LEAVE emp_loop;
29. END IF;
30. -- Do something with the extracted values
31. -- For example, you can print them
32. SELECT emp_id, emp_name, emp_age, emp_salary;
33. END LOOP;
34. CLOSE cur;
35. END //
36. DELIMITER ;
37. CALL extract_employee_values();
38.