Search Results

when I tried

#!/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...

Thanks the intermediate file option worked.

--- Post updated at 08:20 AM ---

RudiC, thanks for your suggestion, unfortunately I could not get it to work.

No longer all on 1 line but still can't get the beginning and end double quote

my version of linux (gotten by typing uname -a)

Linux myhost 3.8.13-68.3.4.el6uek.x86_64 #2 SMP Tue Jul 14...

Thank you for this suggestion.
set colsep '","' works as a column separator but the sed command is not adding the " at the front or end of each line, somehow it is removing the eol. After running...

Thanks for your response. Unfortunately this must be csv separated. The file needs to be automatically generated and the recipient can't handle a pipe delimited file. I don't know how to format the...

I am extracting data via sql query and some of the data has commas. Output File must be csv and I cannot update the data in the db (as it is used by other application).

Example

table...