/ Published in: SQL
Can't find an object? Perhaps it's a Synonym? Find out here!
- -- Is this a Synonym?
- SELECT object_name, OBJECT_TYPE FROM user_objects WHERE object_name = UPPER(:name);
- -- What are you a synonym for?
- SELECT synonym_name, table_name FROM all_synonyms WHERE synonym_name = UPPER(:name);
You need to login to post a comment.