游标和过程/函数pl用于显示雇员姓名的sql

-- 创建一个存储过程
CREATE OR REPLACE PROCEDURE get_employee_names
IS
  -- 声明游标
  CURSOR employee_cursor IS
    SELECT employee_name FROM employees;
  -- 声明变量
  employee_name employees.employee_name%TYPE;
BEGIN
  -- 打开游标
  OPEN employee_cursor;
  -- 循环遍历游标
  LOOP
    -- 从游标中获取数据
    FETCH employee_cursor INTO employee_name;
    -- 退出循环条件
    EXIT WHEN employee_cursor%NOTFOUND;
    -- 显示雇员姓名
    DBMS_OUTPUT.PUT_LINE('Employee Name: ' || employee_name);
  END LOOP;
  -- 关闭游标
  CLOSE employee_cursor;
END;
/

-- 调用存储过程
BEGIN
  get_employee_names;
END;
/