|
SYNONYM
SYNONYM is a schema object used to accessing the tables owned by another user.
Syntax ::
CREATE [PUBLIC] SYNONYM <SYNONYMNAME>
FOR <TABLENAME> ;
Example 1::
CREATE SYNONYM D_CUST
FOR CUSTOMER ;
|
Example 2::
CREATE PUBLIC SYNONYM D_CUST
FOR CUSTOMER ;
|
Remember :: Public synonym can be accessed by all the users.
|
