Shell Programming and Scripting

sed 's/^.*$/"&"/' ${OUTFILE} >${OUTIFILE}-new
 mv ${OUTIFILE}-new ${OUTIFILE}

select '"' & Person, Favorite & '"' from FavoriteThings;

#!/bin/sh

RPTDATE=`date "+%Y%m%d"`

OUTFILE="FavoriteThings.${RPTDATE}.csv"

echo "START $0 at `date`"

sqlplus -s myuser/mypassword@mydb <<EOF
SET PAGESIZE 50000
SET COLSEP ","
SET LINESIZE 500
SET FEEDBACK OFF

SPOOL $OUTFILE
select '"'&Person, &'"'Favorite from FavoriteThings;
SPOOL OFF
EXIT
EOF


echo "END $0 at `date`"

START ./TryFavoriteThings.sh at Fri Jan 25 19:47:50 GMT 2019
Enter value for person: old   1: select '"'&Person, &'"'Favorite from FavoriteThings
new   1: select '"'SPOOL OFF, &'"'Favorite from FavoriteThings
select '"'SPOOL OFF, &'"'Favorite from FavoriteThings
                       *
ERROR at line 1:
ORA-00923: FROM keyword not found where expected