Re: Oracle 10g Express Connection Limitations?

On 6 May, 19:00, "Jason D." <Tron..._at_gmail.com> wrote:
> Interesting...is V$SESSION the same as V_$SESSION ? I found the latter
> when logging on as "sys" under Views in the Object Browser but
> couldn't find one without the underscore.

select object_name, object_type
from dba_objects
where object_name in ('V$SESSION','V_$SESSION');

OBJECT_NAME                    OBJECT_TYPE
------------------------------ ----------------
V_$SESSION                     VIEW
V$SESSION                      SYNONYM

Just as an aside, why is your usage of Oracle XE a summer-based affair? ;)

HTH -g Received on Wed May 07 2008 - 04:58:12 CDT