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>

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

Original text of this message