Monday, August 16, 2010

Oracle 11g: Synonyms

Why use Synonym?
  • create easy reference
  • shorten lengthy object name
===>  SQL Queries:  Create a Synonym
create synonym d_sum
for dept_sum_vu;

Results
create synonym succeeded.


===>  SQL Queries:  Drop a Synonym
drop synonym d_sum;

Results

drop synonym d_sum succeeded.

No comments: