如何使PL/SQL存储过程显示表？

CREATE OR REPLACE PROCEDURE display_employees IS
  -- 声明游标
  CURSOR c_employees IS
    SELECT * FROM employees;
    
  -- 声明变量用于存储行数据
  employee employees%ROWTYPE;
BEGIN
  -- 打开游标
  OPEN c_employees;
  
  -- 循环获取并显示每行数据
  LOOP
    FETCH c_employees INTO employee;
    EXIT WHEN c_employees%NOTFOUND;
    
    -- 在这里可以根据需要对每行数据进行处理或显示
    DBMS_OUTPUT.PUT_LINE('Employee ID: ' || employee.employee_id);
    DBMS_OUTPUT.PUT_LINE('First Name: ' || employee.first_name);
    DBMS_OUTPUT.PUT_LINE('Last Name: ' || employee.last_name);
    -- 其他列类似地显示
    
  END LOOP;
  
  -- 关闭游标
  CLOSE c_employees;
  
  -- 输出结束标记
  DBMS_OUTPUT.PUT_LINE('End of table.');
END;
/

SET SERVEROUTPUT ON;

BEGIN
  display_employees;
END;