Re: database_properties is not a database dictionary view?

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 Received on Sat Apr 19 2003 - 10:58:13 CDT