Re: database_properties is not a database dictionary view?

From: David Fitzjarrell <oratune_at_msn.com>
Date: 21 Apr 2003 06:59:15 -0700
Message-ID: <32d39fb1.0304210559.56b8ea13@posting.google.com>

Daniel Morgan <damorgan_at_exesolutions.com> wrote in message news:<3EA17215.44790589_at_exesolutions.com>...
> charlie cs wrote:
>
> > We are using 9.2.0.2.0 on solaris.
> >
> > When I select from dict
> >
> > SQL> select table_name from dict where
> > upper(table_name)='DATABASE_PROPERTIES';
> >
> > no rows selected
> >
> > but the view is clearly there
> >
> > SQL> select count(*) from database_properties;
> >
> > COUNT(*)
> > ----------
> > 25
> >
> > Is this a bug or what?
> >
> > Thanks
>
> Try this:
>
> SELECT *
> FROM dict
> WHERE UPPER(table_name) LIKE 'D%';
>
> Daniel Morgan

Since it's not a table, but is a view, why would it be listed under a column labelled TABLE_NAME? This query, however, will work:

select view_name
from dba_views
where view_name like 'DA%';

08:56:46 DBTECH> / VIEW_NAME

---

DATABASE_COMPATIBLE_LEVEL
DATABASE_PROPERTIES 08:56:47 DBTECH> David Fitzjarrell Received on Mon Apr 21 2003 - 08:59:15 CDT