SQL PLUS export data to generate text files

SQL PLUS exports data to generate a text file to export data in a table to generate a text file, column and column are separated by "|" www.2cto.com SET echo OFFSET feedback OFFSET newpage noneSET pagesize 5000 SET linesize 500 SET verify OFFSET pagesize 0 SET term OFFSET trims ONSET linesize 600 SET heading OFFSET timing OFFSET verify OFFSET numwidth 38 SPOOL c: \ drop_table.sqlSELECT DEPTNO | '| dname from dept; spool off through the above example, we can set: www.2cto.com echo offset feedback offset ne Wpage noneset pagesize 5000 set linesize 500 set verify offset pagesize 0 set term offset trims onset linesize 600 set heading off set timing offset verify offset numwidth 38 SPOOL c: \ The specific file name of the SQL statement you want to run SPOOL OFF as a template, as long as the necessary statements are assumed to be the template.