oraclel 快捷记录

创建用户：
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