|
Oracle synonym - August 11, 2008 at 15:00 PM by Amit Satpute
What is synonym and how do we create synonym?
Answer
Table references can be complicated. So oracle allows you create
synonym for a complicated reference. It renames a table reference.
Syntax:
CREATE SYNONYM syn_name FOR reference;
This object can be a table, procedure, sequence or any other database object. A
synonym is a Data Dictionary object.
Oracle synonym - Nov 17, 2008 at 15:00 PM by Nishant Kumar
What is the purpose of Synonym in oracle?
Answer - Synonym provide alias name for a table.
Synonym hides name of the table.
With Synonym, you can provide users with less complicated table name than the
real one.
|