Synonym
Synonym:-A synonym is an alias for a table, view, snapshot, sequence, procedure, function,or package.
There are two types to SYNONYMS they are
1) PRIVATE SYNONYM :-This can be access only who created .
2) PUBLIC SYNONYM :-This can be access by any user.
Syntax for Private SYNONYMS:-
Create or replace synonym for ;
Syntax for Public SYNONYMS:-
Create or replace public synonym for ;
CREATE SYNONYMS:-
Example:- Below is the private synonym
SQL>create or replace synonym employee for emp;
Data selection from private synonym:-
SQL>select * from employee;
Example:- Below is the public synonym
SQL>create or replace public synonym employee1 for emp;--Public
Data selection from public synonym:-
SQL>select * from employee1;
Note:- Only public synonym can be access by any user but private synonym can be accessed by creator.
Dropping Synonyms:-
SQL>drop synonym employee; --drop private synonym
SQL>drop public synonym employee1; --drop public synonym
Listing information about synonyms:-
SQL>select * from user_synonyms;