- 积分
- 56
- 鸿鹄币
- 个
- 好评度
- 点
- 精华
- 最后登录
- 1970-1-1
- 阅读权限
- 20
- 听众
- 收听
助理工程师
 
|
发表于 2013-1-3 09:45:36
|
显示全部楼层
FOR emp_rec IN empc LOOP
IF emp_rec.department_id <> olddeptno THEN
UTL_FILE.PUT_LINE (file,'DEPARTMENT: ' || emp_rec.department_id);
END IF;
UTL_FILE.PUT_LINE (file,' EMPLOYEE: ' ||
emp_rec.last_name ||'
earns: ' || emp_rec.salary);
olddeptno := emp_rec.department_id;
END LOOP;
UTL_FILE.PUT_LINE(file,'*** END OF REPORT ***');
UTL_FILE.FCLOSE (file);
... |
|