RE: how to run a sql by passing variable

2007-05-11 Thread Roode, Eric
> 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

RE: how to run a sql by passing variable

2007-05-11 Thread Brian Raven
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

how to run a sql by passing variable

2007-05-10 Thread Praveen G Siddavarapu
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