Synonym

From Oracle FAQ

Jump to: navigation, search

A synonym is an alternative name (or alias) for an object in the database created with the CREATE SYNONYM SQL command.

Examples

Create a synonym:

CREATE SYNONYM emp FOR scott.employees;

Create a public synonym:

CREATE PUBLIC SYNONYM dual FOR sys.dual;

Drop a synonym:

DROP SYNONYM emp;


Glossary of Terms
A B C D E F G H I J K L M N O P Q R S T U V W X Y Z #
Personal tools