同义词
使用同义词访问相同的对象:
l 方便访问其它用户的对象
l 缩短对象名字的长度
//测试同义词的意义
Select * from tab;
Sqlplus sys/pass as sysdba;
Select tname from tab where lower(tname)=’dual’;
Conn scott/scott;
Select sysdate from dual;
//创建同义词
Create public synonym syn_emp for scott.emp;
//删除同义词
Drop synonym syn_emp;