> From: Praveen G Siddavarapu
> Sent: Thursday, May 10, 2007 8:45 PM
> To: activeperl@listserv.ActiveState.com
> Subject: how to run a sql by passing variable
>
>
> All
>
> I have the below sql, it returns two rows, and I need to pass these
> two dates and run
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
Praveen G Siddavarapu
Sent: 11 May 2007 01:45
To: activeperl@listserv.ActiveState.com
Subject: how to run a sql by passing variable
> All
>
> I have the below sql, it returns two rows, and I need to pass these
two date
All
I have the below sql, it returns two rows, and I need to pass these two dates
and run another sql, how do I do that.. basically I need to run the sql two
times with two different time periods
$csr_dates =<<"END_OF_SQL";
SELECT sysdate beg_date
from dual
union
select sysdate -1 beg_date
fro