Oracle PLSQL 学习笔记四

1，使用Cursor For输出Header和DetailSET serveroutput ONBEGINFOR REC1 IN(SELECT * FROM DEPARTMENTS)LOOPDBMS_OUTPUT.PUT_LINE(CHR(10) || '### Department Name : ' || REC1.DEPARTMENT_NAME || '

engchina

481人浏览 · 2016-10-26 16:18:29

engchina · 2016-10-26 16:18:29 发布

1，使用Cursor For输出Header和Detail

SET serveroutput ON
BEGIN
  FOR REC1 IN
  (SELECT * FROM DEPARTMENTS
  )
  LOOP
    DBMS_OUTPUT.PUT_LINE(CHR(10) || '### Department Name : ' || REC1.DEPARTMENT_NAME || ' ####');
    FOR REC2 IN
    (SELECT * FROM EMPLOYEES WHERE DEPARTMENT_ID = REC1.DEPARTMENT_ID
    )
    LOOP
      DBMS_OUTPUT.PUT_LINE(REC2.FIRST_NAME || '''s first day was ' || REC2.HIRE_DATE || '.');
    END LOOP;
  END LOOP;
END;

### Department Name : Administration ####
Jennifer's first day was 03-09-17.

### Department Name : Marketing ####
Michael's first day was 04-02-17.
Pat's first day was 05-08-17.