Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: ksh select value into variable from v$ view
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-lReceived on Fri Jul 22 2005 - 12:59:55 CDT
![]() |
![]() |