Oracle Synonyms Urgent!!!!!

From: <pbhanu_at_yahoo.com>
Date: Thu, 31 Dec 1998 17:58:40 GMT
Message-ID: <76ge0g$2ep$1@nnrp1.dejanews.com>

Thanks a lot for the prompt info ,
But there is a small doubt ,
suppose i create a private synonym in scott for table DEPT as SYN_DEPT , it shows as

SYN_DEPT SCOTT DEPT Bad Link

wherein i need to see

SYN_DEPT SCOTT DEPT Table

how can i change the following query for that

select /*+ FIRST_ROWS */ synonym_name ,table_owner , table_name , nvl(object_type, 'Bad Link')
from all_synonyms a , all_objects b
where a.table_name = b.object_name(+)
and table_owner = b.owner(+)
and nvl(object_type,'Bad Link') in

( 'Bad Link' , 'TABLE', 'VIEW', 'SEQUENCE', 'PROCEDURE',
'FUNCTION',
'PACKAGE', 'SNAPSHOT', 'SYNONYM' )

order by synonym_name , table_name , object_type /
Thanks
Bhanu

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Thu Dec 31 1998 - 11:58:40 CST