advanced code snippet search

Posted By

geekzspot on 01/10/13


Tagged


Versions (?)

Oracle Synonym finder

 / Published in: SQL
 

Can't find an object? Perhaps it's a Synonym? Find out here!

Expand | Embed | Plain Text 
  1. -- Is this a Synonym?
  2. SELECT object_name, OBJECT_TYPE FROM user_objects WHERE object_name = UPPER(:name);
  3.  
  4. --  What are you a synonym for?
  5. SELECT synonym_name, table_name FROM all_synonyms WHERE synonym_name = UPPER(:name);

Report this snippet  

You need to login to post a comment.