Oracle PL/SQL :搜索记录类型值

CREATE TABLE departments (
    dept_id NUMBER,
    dept_name VARCHAR2(50)
);

CREATE TABLE employees (
    emp_id NUMBER,
    emp_name VARCHAR2(50),
    emp_salary NUMBER,
    dept_id NUMBER
);

INSERT INTO departments VALUES (1, 'HR');
INSERT INTO employees VALUES (101, 'John Doe', 5000, 1);
INSERT INTO employees VALUES (102, 'Jane Smith', 6000, 1);

DECLARE
    TYPE employee_record IS RECORD (
        emp_id NUMBER,
        emp_name VARCHAR2(50),
        emp_salary NUMBER
    );

    emp_info employee_record;
BEGIN
    SELECT emp_id, emp_name, emp_salary INTO emp_info
    FROM employees
    WHERE dept_id = 1 AND emp_name = 'John Doe';

    DBMS_OUTPUT.PUT_LINE('Employee ID: ' || emp_info.emp_id);
    DBMS_OUTPUT.PUT_LINE('Employee Name: ' || emp_info.emp_name);
    DBMS_OUTPUT.PUT_LINE('Employee Salary: ' || emp_info.emp_salary);
END;
/

BEGIN
    SELECT emp_id, emp_name, emp_salary INTO emp_info
    FROM employees
    WHERE dept_id = 1 AND emp_name = 'John Doe';

    DBMS_OUTPUT.PUT_LINE('Employee ID: ' <= emp_info.emp_id);
    DBMS_OUTPUT.PUT_LINE('Employee Name: ' <= emp_info.emp_name);
    DBMS_OUTPUT.PUT_LINE('Employee Salary: ' <= emp_info.emp_salary);
EXCEPTION
    WHEN NO_DATA_FOUND THEN
        DBMS_OUTPUT.PUT_LINE('No employee found with the given criteria.');
END;
/