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: v$_ vs v_$ ?

Re: v$_ vs v_$ ?

From: Daniel Morgan <dmorgan_at_exesolutions.com>
Date: Tue, 30 Apr 2002 22:13:03 GMT
Message-ID: <3CCF16ED.4A2F4BDA@exesolutions.com>


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

you could find this out by looking at object_type in all_objects.

Daniel Morgan Received on Tue Apr 30 2002 - 17:13:03 CDT

Original text of this message

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