同义词:
类似于别名
作用:
简化代码
语法
创建:
create 【public】synonym synonym_name for object
create synonym b for books;
例子:根据身份证返回年龄
create or replace function get_age_by_certificateId(certificateId char)
return number
is
brith char(4);
age number(2);
begin
select substr(certificateId,7,4) into brith from dual;
age:=to_number(to_char(sysdate,'yyyy'))-to_number(brith);
return age;
end get_age_by_certificateId;
create synonym gabc for get_age_by_certificateId;
select gabc(140728199411240030) from dual;
object指的是数据库对象的名字
删除
drop [public] synonym synonym_name
drop synonym gabd;