Difference between revisions of "SYNONYM"
Jump to navigation
Jump to search
| Line 5: | Line 5: | ||
'''This will create an alias name for the sales table ''' | '''This will create an alias name for the sales table ''' | ||
CREATE SYNONYM INVENTORY_DATA FOR SALES; | 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