Unix to Oracle / Back
From: The Magnet <art_at_unsu.com>
Date: Thu, 16 Jul 2009 14:03:34 -0700 (PDT)
Message-ID: <6ecda396-2a47-4410-af74-e20cfc1513d7_at_c2g2000yqi.googlegroups.com>
Date: Thu, 16 Jul 2009 14:03:34 -0700 (PDT)
Message-ID: <6ecda396-2a47-4410-af74-e20cfc1513d7_at_c2g2000yqi.googlegroups.com>
I'm trying to accomplish this:
estimates=`sqlplus -s $user/${password} << " EOF"
set heading off feedback off verify off timing off
SELECT count(*)
FROM daily_estimates
WHERE TO_CHAR(date_appended,'YYYYMMDD') = '$yyyymmdd';
exit
EOF`
I get nothing. If I hard code an actual date in there, it works
fine. Why is Oracle not resolving the variable? I've seen this on
many pages and it works fine there.......
Oracle 10g R2. Using ksh......
Many thanks! Received on Thu Jul 16 2009 - 16:03:34 CDT