Difference between revisions of "SYNONYM"
Jump to navigation
Jump to search
| Line 3: | Line 3: | ||
* Data independence | * Data independence | ||
* Location transparency | * Location transparency | ||
'''This will create an alias name for the sales table ''' | |||
CREATE SYNONYM INVENTORY_DATA FOR SALES; | |||
[[#Select Command|Back To Top]]-[[Main_Page| Home]] - [[Oracle_SQL|Category]] | [[#Select Command|Back To Top]]-[[Main_Page| Home]] - [[Oracle_SQL|Category]] | ||
Revision as of 17:22, 14 November 2017
SYNONYM is an alternative name for a table, view, sequence, procedure, stored function
The main advantage is that they provide
- Data independence
- Location transparency
This will create an alias name for the sales table
CREATE SYNONYM INVENTORY_DATA FOR SALES;