Mini Tip: Synonyms
Posted in ITToolbox by Lewis The full link for the article is here . Today I am going to talk about synonyms and what you should NOT do with them. Since this is a MINI tip, it will be short and sweet. I will not cover every aspect of synonyms. A quick definition: two words that can be interchanged in a context are said to be synonymous relative to that context. In Oracle terms: An alias for a table, view, materialized view, sequence, procedure, function, package, type, Java class schema object, user-defined object type, or another synonym. So that means that instead of referencing a table like owner.table, you can create a synonym for that owner.table and reference it by the synonym name. For example, SQL> connect system@unixxe Enter password: ****** Connected. SQL> select count(*) from employees; select count(*) from employees * ERROR at line 1: ORA-00942: table or view does not exist . . SQL> select count(*) from hr.employees; . COUNT(*) ---------- 107 . SQL> create publi...