PLSQL Cursor For Loop handle header and detail

SET serveroutput ONSET verify OFFBEGINFOR rec1 IN(SELECT * FROM DEPT)LOOPDBMS_OUTPUT.PUT_LINE(CHR(10) || '### 部門名 : ' || REC1.department_name || ' ####'); -- CHR(10)换行FOR rec2

engchina

485人浏览 · 2017-01-26 14:14:33

engchina · 2017-01-26 14:14:33 发布

SET serveroutput ON
SET verify OFF
BEGIN
  FOR rec1 IN
  (SELECT * FROM DEPT
  )
  LOOP
    DBMS_OUTPUT.PUT_LINE(CHR(10) || '### 部門名 : ' || REC1.department_name || ' ####'); -- CHR(10)换行
    FOR rec2 IN
    (SELECT * FROM EMP WHERE department_id = REC1.department_id
    )
    LOOP
      dbms_output.put_line(REC2.employee_id || ' ' || REC2.first_name || ' ' || REC2.hire_date);
    END LOOP;
  END LOOP;
END;
/
SET verify ON

CSDN学习社区

CSDN联合极客时间，共同打造面向开发者的精品内容学习社区，助力成长！

更多推荐