Answer to Question #207675 in Databases | SQL | Oracle | MS Access for Oraclebless

Question

1.Write a procedure that displays the number of countries in a given region (prompt for value) whose highest elevations exceed a given value (prompt for value). The procedure should accept two formal parameters, one for a region_id and the other for an elevation value for comparison. Use DBMS_OUTPUT.PUT_LINE to display the results in a message. Test your procedure using the value 5 for the region_id and 2000 for the highest evaluation

Answer 1

USE `employeemanagementsystem`;
DROP procedure IF EXISTS `new_procedure`;
DELIMITER $$
USE `employeemanagementsystem`$$
CREATE PROCEDURE `new_procedure` ()
BEGIN
select region_id as DBMS_OUTPUT,highest_elevation as PUT_LINE
from table_name
where highest_elevation>2000;
END$$
DELIMITER ;