在Oracle中批量收集

SELECT * FROM employees WHERE department = 'IT';

DECLARE
  CURSOR emp_cur IS SELECT * FROM employees WHERE department = 'IT';
  emp_rec emp_cur%ROWTYPE;
BEGIN
  OPEN emp_cur;
  LOOP
    FETCH emp_cur INTO emp_rec;
    EXIT WHEN emp_cur%NOTFOUND;
    -- 处理每一行数据
    DBMS_OUTPUT.PUT_LINE('Employee Name: ' || emp_rec.first_name || ' ' || emp_rec.last_name);
  END LOOP;
  CLOSE emp_cur;
END;

SET HEADING OFF
SET FEEDBACK OFF
SET TERMOUT OFF
SET ECHO OFF
SET NEWPAGE NONE
SET LINESIZE 1000
SET PAGESIZE 0
SPOOL employees.txt
SELECT * FROM employees WHERE department = 'IT';
SPOOL OFF
EXIT

sqlplus username/password@connect_string @employees.sql