Public Synonyms in Oracle PL/SQL

Public Synonyms

By creating a Public Synonym you allow the user to reference the table name without using the schema owner prefixed on the record name (i.e. SYSADM.PS_VENDOR). This also eliminates the need to perform an ALTER SESSION  command.

Example:

How to find tables that do not have a public synonym.

Use the following example to find tables that do not have a public synonym.