wyp6468893的博客

Linux下Oracle数据库定时备份，及数据库恢复

1.fetchSize流式查询方式，注意值的大小，值大于要查的总量<select id="queryRegionList" resultType="com.zw.admin.server.model.Regioninfo" fetchSize="3200"> select * from regioninfo t where t.parentid in (select t.i...

1.是想生成GUID吗？select sys_guid() from dual ;insert into luxian_info (id)values(sys_guid());SYS_GUID()2.往Oracle数据库插入日期数据INSERT INTO FLOOR VALUES ( to_date ( '2007-12-20 18:31:34' , 'YYYY-MM-DD...

1.针对插入获取自增主键的方式oracle为下面例子创建自增序列create sequence seqid minvalue 1 maxvalue 9999999999999999 start with 1 increment by 1select seqid.nextval from dual;CREATE SEQUENCE sequ_id INCREMENT BY 1 NO...