同义词:表或者视图的别名
普通,公共
创建:
公共:SQL> create public synonym ss1 for dmhr.employee;
普通:SQL> create synonym ss for dmhr.employee;
修改同义词:
create or replace synonym ss for dmhr.employee;
删除同义词:
SQL> drop synonym ss;
SQL> drop public synonym ss1;
同义词:表或者视图的别名
普通,公共
创建:
公共:SQL> create public synonym ss1 for dmhr.employee;
普通:SQL> create synonym ss for dmhr.employee;
修改同义词:
create or replace synonym ss for dmhr.employee;
删除同义词:
SQL> drop synonym ss;
SQL> drop public synonym ss1;