On Mon, Jun 25, 2001 at 02:24:21PM -0400, Chas Owens wrote:
> Let me see if I have this straight:
>
> Perl was ignoring $session because of the \ and then passing the output
> to the shell (stripping the \).
Yes.
> The shell saw $session so it tried to replace it with the enviromental
> varia
On 25 Jun 2001 10:14:57 -0800, Michael Fowler wrote:
> On Mon, Jun 25, 2001 at 02:09:59PM -0400, Chas Owens wrote:
> > @active = qx(
> > sqlplus -S $RTDUSER/$RTDPASS\@$RTD_ORACLE_SID <<-!
> > select count(distinct(process)) ACTIVE from v\\\$session
> > where last_call_et < 60 and
> > process in (s
On Mon, Jun 25, 2001 at 02:09:59PM -0400, Chas Owens wrote:
> @active = qx(
> sqlplus -S $RTDUSER/$RTDPASS\@$RTD_ORACLE_SID <<-!
> select count(distinct(process)) ACTIVE from v\\\$session
> where last_call_et < 60 and
> process in (select ltrim(rtrim(to_char(process_id) )) from
> session_list);
>
On 25 Jun 2001 09:47:08 -0800, Michael Fowler wrote:
> On Mon, Jun 25, 2001 at 01:09:51PM -0400, Chas Owens wrote:
> > On 25 Jun 2001 12:57:39 -0400, Yacketta, Ronald wrote:
> > > > select count(distinct(process)) ACTIVE from " . 'v$session' . "
>
> > > > select count(distinct(process)) ACTIVE fr
On Mon, Jun 25, 2001 at 01:09:51PM -0400, Chas Owens wrote:
> On 25 Jun 2001 12:57:39 -0400, Yacketta, Ronald wrote:
> > > select count(distinct(process)) ACTIVE from " . 'v$session' . "
> > > select count(distinct(process)) ACTIVE from " . 'v\$session' . "
>
> What version of Perl are you using
On 25 Jun 2001 12:57:39 -0400, Yacketta, Ronald wrote:
> This one was really close :)
> I had to change
> > select count(distinct(process)) ACTIVE from " . 'v$session' . "
>
> to
> > select count(distinct(process)) ACTIVE from " . 'v\$session' . "
>
> and it worked!
>
> Thanxs everyone!
>
> Ro
This one was really close :)
I had to change
> select count(distinct(process)) ACTIVE from " . 'v$session' . "
to
> select count(distinct(process)) ACTIVE from " . 'v\$session' . "
and it worked!
Thanxs everyone!
Ron
:@active = qx(
:sqlplus -S $RTDUSER/$RTDPASS\@$RTD_ORACLE_SID <<-!
:select count(distinct(process)) ACTIVE from ---> v$session <---
:where last_call_et < 60 and
:process in (select ltrim(rtrim(to_char(process_id) )) from
:session_list);
:quit
:!
:);
Oh... Didn't see the other variables you were
On 25 Jun 2001 12:15:15 -0400, Yacketta, Ronald wrote:
> this is what I am trying todo
>
> @active = qx(
> sqlplus -S $RTDUSER/$RTDPASS\@$RTD_ORACLE_SID <<-!
> select count(distinct(process)) ACTIVE from ---> v$session <---
> where last_call_et < 60 and
> process in (select ltrim(rtrim(to_char(p
:@active = qx(
:sqlplus -S $RTDUSER/$RTDPASS\@$RTD_ORACLE_SID <<-!
:select count(distinct(process)) ACTIVE from ---> v$session <---
:where last_call_et < 60 and
:process in (select ltrim(rtrim(to_char(process_id) )) from
:session_list);
:quit
:!
:);
Ok, so you're using qx(foo), which is the same
> -Original Message-
> From: Stephen Neu [mailto:[EMAIL PROTECTED]]
> Sent: Monday, June 25, 2001 12:04 PM
> To: Perl Beginners (E-mail)
> Subject: RE: escaping v$session
>
>
> Try 'v$session' instead of "v$session"
> The single quot
o
// yes
:-Original Message-
:From: Yacketta, Ronald [mailto:[EMAIL PROTECTED]]
:Sent: Monday, June 25, 2001 10:45 AM
:To: Beginners (E-mail)
:Subject: escaping v$session
:
:
:Folks,
:
:I am trying to get some stats from a oracle DB (cant use DBI,
:dont ask why)
:I need to escape
Folks,
I am trying to get some stats from a oracle DB (cant use DBI, dont ask why)
I need to escape out v$session, but cant seem to find the right magic :(
I have tried
v\$session and get the ugly so such table or view
Ron
13 matches
Mail list logo
