Oracle PL/SQL:如何美观地打印大量数据

DECLARE
  CURSOR c_data IS
    SELECT * FROM your_table;
BEGIN
  FOR rec IN c_data LOOP
    DBMS_OUTPUT.PUT_LINE(rec.column1 || ' ' || rec.column2);
  END LOOP;
END;
/

DECLARE
  file_handle UTL_FILE.FILE_TYPE;
  file_path VARCHAR2(100) := 'YOUR_DIRECTORY/YOUR_FILE.txt';
BEGIN
  file_handle := UTL_FILE.FOPEN('YOUR_DIRECTORY', 'YOUR_FILE.txt', 'W');
  
  FOR rec IN (SELECT * FROM your_table) LOOP
    UTL_FILE.PUT_LINE(file_handle, rec.column1 || ' ' || rec.column2);
  END LOOP;
  
  UTL_FILE.FCLOSE(file_handle);
END;
/

SET PAGESIZE 100
SET LINESIZE 100
SET COLSEP ' '

SELECT * FROM your_table;