创建用户:
create user hysrm_demo identified by hysrm_demo;
//把dba的权限赋给创建的用户
grant dba to hysrm_demo;
创建视图:
CREATE OR REPLACE FORCE VIEW “HJERP”.“table_v” (“field1”, “field2”) AS
select 1,1 from dual
创建序列:
– sys_wechat_user主键序列
create sequence seq_sys_wechat_user
increment by 1
start with 10
nomaxvalue
nominvalue
cache 20;
查询下一个序列:
select 序列名.nextval from dual;
修改序列间隔的值(用户修改序列当前值)
alter sequence 序列名 increment by -2;
分页
SELECT * FROM ( SELECT t., rownum FROM table1 t WHERE CONDITION ) WHERE rownum >( pangeNow - 1 ) 5 AND rownum <=( pageNow )*5