同义词(为了所引用表,写重复代码 )
当操作另外用户的表时,需要写出该用户名 如select * from scott.dept
创建同义词,则可简化这种操作
建:create synonym dept for scott.dept; 适合当前用户
删: drop synonym dept
建公共同义词: create public synonym dept for scott.dept
desc dba synonms
同义词(为了所引用表,写重复代码 )
当操作另外用户的表时,需要写出该用户名 如select * from scott.dept
创建同义词,则可简化这种操作
建:create synonym dept for scott.dept; 适合当前用户
删: drop synonym dept
建公共同义词: create public synonym dept for scott.dept
desc dba synonms