Facebook
From rizan, 11 Months ago, written in SQL.
Embed
Download Paste or View Raw
Hits: 261
  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.