Oracle - Creating Synonym | Oracle Synonym

►Title:

Oracle - Creating Synonym | Oracle Synonym


►Content:
grant privilege for synonym
---------------------------
grant create synonym
to dba167;


let login to dba167
-------------------------------


Check tables
----------------------
select *
from user_tables;


to see user synonym
----------------------
select *
from user_synonyms;


create synonym
----------------------
create synonym Emp_syno
for emp;


to see user synonym
----------------------
select *
from user_synonyms;


get data froo synonym
----------------------
select *
from Emp_syno


Drop synonym
------------------
drop synonym Emp_syno


🔗LINKS🔗
Website: http://rejawebs.com/#/
LinkedIn:   / md-rezoyanul-islam-096a3775  


►►► Find me on Social Media◄◄◄
Facebook:   / rezoyanul.reza  


✉ Contact with me
Email: mailto:[email protected]


❤ Make sure you SUBSCRIBE and be the 1st one to view newly created videos!




keys: Oracle - Creating Synonym | Oracle Synonym
Grant Privilege for Synonym,Check User's Synonyms,Create Synonym,Get Data From Synonym,Drop Synonym