Live ORACLE

DECLARE

  emp_id    employees.employee_id%TYPE := 100;

   emp_name  employees.last_name%TYPE;

   wages     NUMBER(7,2);

BEGIN

  SELECT last_name,

         salary + (salary * Nvl(commission_pct,0))

  INTO   emp_name,wages

  FROM   employees

  WHERE  employee_id = emp_id;

 

  dbms_output.Put_line('Employee '

                       ||emp_name

                       ||' might make '

                       ||wages);

END;

/

Assigning a Query Result to a Variable