CREATE OR REPLACE FUNCTION NUMAR_ORASE(p_country_id IN VARCHAR2)
RETURN NUMBER IS
v_numar_orase NUMBER;
BEGIN
SELECT COUNT(*) INTO v_numar_orase
FROM locations
WHERE country_id = p_country_id;

RETURN v_numar_orase;  

END NUMAR_ORASE;
/