thinkerbot · January 13, 2012 19:19
diff --git a/export.sql b/export.sql
 -- sqlplus -S user/pass@conn @export.sql > column_output.txt

 set colsep '|'
 set echo off
 set feedback off
 set linesize 1000
 set pagesize 0
 set sqlprompt ''
 set trimspool on
 set headsep off

 select a||' '||b from c;
 exit;
	-- sqlplus -S user/pass@conn @export.sql > column_output.txt

	set colsep '\|'
	set echo off
	set feedback off
	set linesize 1000
	set pagesize 0
	set sqlprompt ''
	set trimspool on
	set headsep off

	select a\|\|' '\|\|b from c;
	exit;