Home > database >  The oracle database spool export file, a record will be how to solve a new line?
The oracle database spool export file, a record will be how to solve a new line?

Time:09-29

The set SQLBL on;
The set define off;
The set pagesize 0;
The set termout off;
Set the echo off;
The set feedback;
Set the heading off;
The set trimout on;
The set trimspool off;
The set verify off;
The set linesize 1000;
Set long 1000;
Col ci format a5000;
A record 17 fields, has set the line width is 1000, but a record will be a line break into 5 lines. Such import big data platform will be identified into 5 records, is there a way to make a record is a row to beg god for help!
  • Related