Search Results

My SQL is way beyond rusty, so to say corroded away, but couldn't you



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

Please use the code tags for code, like it tells you in the message window. You either need to use the in-place option to sed, or use an intermediate file, like this
sed 's/^.*$/"&"/' ${OUTFILE}...

Or perhaps:
set colsep '","'
And then run the output through sed to add the outer two double quotes:
sqlplus -s myuser/mypassword@mydb | sed 's/.*/"&"/' <<EOF

I think in sqlplus there is a colsep setting.
set colsep |
to set to a | pipe character

you can then do a manual export into Excel, specifying the | as delimiter or
edit(replace) the , to ; and...