Re: v$_ vs v_$ ?

Good! Now I understand.
Thank you, Stan!
Rosaline

Stan wrote:

> I think your getting confused here. v$_lock is a synonym for
> sys.v_$_lock view and v$lock is a synonym for v_$lock view. Their source
> views are totally different and hence the difference.
>
> so as daniel said, v_$ -- > view of x$tables and v$_ -- > synonym.
>
> hth,
> -Stan
>
> Fan Ruo Xin wrote:
>
> >
> > Daniel Morgan wrote:
> >
> >
> >>Fan Ruo Xin wrote:
> >>
> >>
> >>>Hi,
> >>>What's the difference between v$_.. and v_$... ?
> >>>Thanks for any help!
> >>>Rosaline
> >>>
> >>One is a synonym and one is the actual object.
> >>
> >>v$_ = synonym
> >>v_$ = view
> >>
> >>
> >
> > Then why there is a little difference between v$_lock and v_$lock?
> > Thank you, Daniel!
> >
> >
> >>you could find this out by looking at object_type in all_objects.
> >>
> >>Daniel Morgan
> >>
> >
Received on Wed May 01 2002 - 07:39:51 CDT