Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Public synonyms - unusual names

604542Dec 28 2007 — edited Dec 31 2007
I'm trying to list public synonyms but the names that they seem to have been given are a little strange. Have I missed something ?

SELECT owner, object_name, object_type
FROM all_objects
WHERE object_type like 'SYNONYM';
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 28 2008
Added on Dec 28 2007
9 comments
548 views