UNIX Desktop Questions & Answers

test@ORA11G>
test@ORA11G> -- The data in my Oracle table looks like this
test@ORA11G> select * from t;
         X Y Z         W
---------- - --------- ----------------------------------------------------------------------------------------------------
         1 a 19-SEP-08 the quick brown fox
         2 b 19-OCT-08 @#$ jumps over the ::
         3 c 19-NOV-08 lazy dog...
         4 d 19-DEC-08 abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789~!@#$%^&*()_+{}|:"<>?`-=[]\;',./
4 rows selected.
test@ORA11G>
test@ORA11G>

$
$ # display the content of the shell script
$ cat tst.sh
#!/usr/bin/bash
sqlplus -s test/test <<EOF >outfile.log
SET NEWPAGE NONE
SET LINESIZE 9999
SET TRIMSPOOL ON
SET FEEDBACK OFF
SET VERIFY OFF
SET UNDERLINE OFF
SET COLSEP ","
select * from t;
exit
EOF
$
$ # source the shell script
$ . tst.sh
$
$ # check the generated flat file
$ cat outfile.log
         X,Y,Z        ,W
         1,a,19-SEP-08,the quick brown fox
         2,b,19-OCT-08,@#$ jumps over the ::
         3,c,19-NOV-08,lazy dog...
         4,d,19-DEC-08,abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789~!@#$%^&*()_+{}|:"<>?`-=[]\;',./
$
$