Re: Question on a select statement

Why don't u use the DBA_DEPENDENCIES view???? it does all this for u.

Marc

yong321_at_yahoo.com wrote:

> I want to look at some entries in sys.public_dependency view. But it
> contains columns object_id and referenced_object_id instead of
> object_name. I want to view them as names. This is my select statement:
>
> select a.object_name,b.object_name
> from sys.public_dependency c,all_objects a,all_objects b
> where c.object_id=a.object_id and c.referenced_object_id=b.object_id
>
> It seems to show the result correctly. But I want to confirm with
> experts in this newsgroup. Thanks.
>
> Yong
> Email:yong321_at_yahoo.com
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.
Received on Tue Jul 06 1999 - 14:19:01 CDT