Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: ksh select value into variable from v$ view

Re: ksh select value into variable from v$ view

From: Barbara Baker <barb.baker_at_gmail.com>
Date: Fri, 22 Jul 2005 11:57:24 -0600
Message-ID: <47a6f72b05072210577f65e323@mail.gmail.com>


Thanks to all for the quick responses, but especially Mangus and Somckit.

Putting in 2 slashes instead of 1 does the trick!

On 7/22/05, Barbara Baker <barb.baker_at_gmail.com> wrote:
> Solaris 9 Oracle 9.2.0.4
> Hi! I'm trying to grab a process id from the database and store it in
> a variable. This syntax works if I'm not using a v$ view. If I use a
> v$ view, it ignores what's after the $. I've tried v\$ and v_\$ , but
> neither work.
>

--
http://www.freelists.org/webpage/oracle-l
Received on Fri Jul 22 2005 - 12:59:55 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US