Halo数据库同义词功能演示

create synonym synonym_name for schema_name.object_name;

create view oracle.vb as select * from dual;create synonym syn_b for oracle.vb;select * from syn_b;drop synonym syn_b;

create table oracle.tc(a int);create synonym syn_c for oracle.tc;select * from syn_c;insert into syn_c values(1);select * from syn_c;drop synonym syn_c;

create procedure oracle.protestdas beginraise notice 'oracle.protestd';end;/create synonym syn_d for oracle.protestd;call syn_d;drop synonym syn_d;

create function oracle.ftestf(a int,b int)return intas beginreturn a + b;end;/create synonym syn_f for oracle.ftestf;select syn_f(25,26);drop synonym syn_f;

CREATE  SEQUENCE oracle.seq_truck_num MINVALUE 1 MAXVALUE 9223372036854775807 INCREMENT BY 1 START with 5258752  CACHE 20;create or replace SYNONYM sy_car_seq_truck_num for oracle.seq_truck_num;select sy_car_seq_truck_num.nextval from dual;drop synonym sy_car_seq_truck_num;

CREATE OR REPLACE PACKAGE pkg_a ASFUNCTION f_test( f_a IN INTEGER , f_b IN INTEGER ) RETURN INTEGER;PROCEDURE pro_test;END pkg_a;/CREATE OR REPLACE PACKAGE BODY pkg_a ASFUNCTION f_test( f_a IN INTEGER , f_b IN INTEGER )RETURN INTEGERASf_c INTEGER;BEGIN f_c := f_a + f_b;RETURN f_c;END f_test;
PROCEDURE pro_testAS a INTEGER;BEGINa:= pkg_a.f_test(12,13);RAISE NOTICE 'pkg_a.f_test(12,13) = %',a; END pro_test; END pkg_a;/
-- 创建package同义词 create synonym pkggg for pkg_a;
-- 测试调用函数/存储过程DECLARE   a INTEGER;BEGIN  pkggg.pro_test();  a:=pkggg.f_test(10,13);  RAISE NOTICE 'a : %',a;END;/drop synonym pkggg;drop package pkg_a;