Synonyms It allows short names or alternative names for objects.
Example:
CREATE SYNONYM D30
FOR EMPD30;
Now if we give command:
SELECT * FROM D30;
|
NAME
|
MINSAL
|
MAXSAL
|
AVGSAL
|
|
---------------------
|
------------
|
-------------
|
--------------
|
|
ACCOUNTING
|
1300
|
5000
|
2916.6667
|
|
RESEARCH
|
800
|
3000
|
2175
|
|
SALES
|
950
|
2850
|
1566.6667
|