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

Home -> Community -> Usenet -> c.d.o.server -> Re: About V$SESSION an column length

Re: About V$SESSION an column length

From: Reza <reza_at_digital-dispatch.co.uk>
Date: Fri, 14 Jan 2000 20:44:24 -0000
Message-ID: <947882890.12727.0.nnrp-04.d4f07aaa@news.demon.co.uk>


the underlying table for this view has this column width as varchar2(64), so I think the underlying x$ fixed tabe has its length truncated to 64 character. So probably yo have no choice. Reza

Cédric AVENAS <cedric.avenas_at_ad6.com> wrote in message news:85n1hs$ah2$1_at_news.imaginet.fr...
> I can't see the whole path of a program when I query the program column in
> v$SESSION. The limit is about 64 char and my path is longer. Is there
> another way to get the whole path (in fact, it's the exe name that I would
> get)?
>
>
Received on Fri Jan 14 2000 - 14:44:24 CST

Original text of this message

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