Oracle实践--PL/SQL基础之同义词和序列
时间:2022-03-10 17:09
create or replace synonym em for emp; select *from em; drop synonym em;
--创建公有的同义词,可以被所有的数据库用户访问,当然别的用户要有访问权限
create or replace synonym em for emp; select *from em; drop synonym em;
/*
序列:用于生成唯一,连续序号的对象,可以使升序,也可以使降序
*/
create or replace synonym em for emp; select *from em; drop synonym em;
--查询序列
select my_seq.nextval from dual;-- 序列下一个值 select my_seq.currval from dual;-- 序列当前值 create table person( pid number primary key, pname varchar2(20) )
文章来源:
Oracle实践--PL/SQL基础之同义词和序列,布布扣,bubuko.com