Difference between revisions of "SYNONYM"

From rbachwiki
Jump to navigation Jump to search
(Created page with "==SYNONYM is an alternative name for a table, view, sequence, procedure, stored function The main advantage is that they provide * Data independence * Location transparency...")
 
 
(3 intermediate revisions by the same user not shown)
Line 1: Line 1:
==SYNONYM is an alternative name for a table, view, sequence, procedure, stored function
==SYNONYM is an alternative name for a table, view, sequence, procedure, stored function==
The main advantage is that they provide
The main advantage is that they provide
* 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

Back To Top- Home - Category