Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SET SERVEROUTPUT ON;
- DECLARE
- num_emp NUMBER(5):='&Numero_Empleado_Mostrar';
- v_nombre HR.EMPLOYEES.FIRST_NAME%TYPE;
- v_apellido HR.EMPLOYEES.LAST_NAME%TYPE;
- v_salario HR.EMPLOYEES.SALARY%TYPE;
- v_nombre_dpto HR.DEPARTMENTS.DEPARTMENT_NAME%TYPE;
- v_nombre_ciudad HR.LOCATIONS.CITY%TYPE;
- --variables auxiliares
- v_numero_dep HR.DEPARTMENTS.DEPARTMENT_ID%TYPE;
- v_location_id HR.LOCATIONS.LOCATION_ID%TYPE;
- BEGIN
- SELECT FIRST_NAME,LAST_NAME,SALARY,DEPARTMENT_ID INTO v_nombre, v_apellido, v_salario, v_numero_dep FROM HR.EMPLOYEES WHERE EMPLOYEE_ID = num_emp;
- SELECT DEPARTMENT_NAME,LOCATION_ID INTO v_nombre_dpto, v_location_id FROM HR.DEPARTMENTS WHERE DEPARTMENT_ID = v_numero_dep;
- SELECT CITY INTO v_nombre_ciudad FROM HR.LOCATIONS WHERE LOCATION_ID = v_location_id;
- DBMS_OUTPUT.PUT_LINE('****************************');
- DBMS_OUTPUT.PUT_LINE('****************************');
- DBMS_OUTPUT.PUT_LINE('**** Nombre: ' || v_nombre);
- DBMS_OUTPUT.PUT_LINE('**** Apellido : ' || v_apellido);
- DBMS_OUTPUT.PUT_LINE('**** Salario: ' || v_salario);
- DBMS_OUTPUT.PUT_LINE('**** Departamento: ' || v_nombre_dpto);
- DBMS_OUTPUT.PUT_LINE('**** Ciudad: ' || v_nombre_ciudad);
- DBMS_OUTPUT.PUT_LINE('****************************');
- DBMS_OUTPUT.PUT_LINE('****************************');
- END;
- /
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement