Difference between revisions of "SYNONYM"
Jump to navigation
Jump to search
| (One intermediate revision by the same user not shown) | |||
| 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; | |||
==DROP SYNONYM NAME == | |||
DROP SYNONYM INVENTORY_DATA | |||
[[#Select Command|Back To Top]]-[[Main_Page| Home]] - [[Oracle_SQL|Category]] | [[#Select Command|Back To Top]]-[[Main_Page| Home]] - [[Oracle_SQL|Category]] | ||
Latest revision as of 17:24, 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;
DROP SYNONYM NAME
DROP SYNONYM INVENTORY_DATA