curso-plsql

CREATE OR REPLACE PROCEDURE maximo
--(nombre VARCHAR2)
IS
max_val NUMBER(8);
user_name VARCHAR2(8);
BEGIN
SELECT Max(sal)
INTO max_val
from emp;
Select ename
into user_name
from emp where sal=max_val;

dbms_output.put_line('El maximo salario es = '
|| user_name || '!');

EXCEPTION
WHEN NO_DATA_FOUND THEN
dbms_output.put_line('No se encuentra el usuario '
|| user_name || '!');
END;
/