oracle
ioxyj
这个作者很懒,什么都没留下…
展开
-
分页
SELECT ID, RN FROM (SELECT ROWNUM RN, ID FROM (SELECT RY.ID ID FROM T_SQJZ_RYMC RY WHERE 1 = 1 ORDER BY startTime desc nu原创 2015-04-13 08:59:56 · 144 阅读 · 0 评论 -
oracle之type
CREATE OR REPLACE TYPE "RESULT_CURSTARTANDEND"原创 2016-06-15 09:53:01 · 222 阅读 · 0 评论 -
oracle函数及type
CREATE OR REPLACE TYPE "RESULT_CURSTARTANDEND"原创 2016-05-27 15:10:09 · 628 阅读 · 0 评论 -
机构统计
WITH TIME_VIEW AS (SELECT STARTDATE, ENDDATE, STARTTIME, ENDTIME FROM TABLE(SELECT_STARTEND('$time$'))), ORGAN_TREE AS (SELECT O.ID, O.ORGAN, O.FATHEROR原创 2016-01-29 13:37:46 · 175 阅读 · 0 评论 -
个人统计
SELECT NVL(T2.TEMP_COUNT, 0) tldp, FROM RYMC_VIEW T1 LEFT JOIN (SELECT COUNT(TT.ID) TEMP_COUNT, TT.ID FROM ZHUSU_VIEW TT GROUP BY ID) T2 ON T1.ID = T2.ID原创 2016-01-29 13:23:07 · 213 阅读 · 0 评论 -
一人一条最新
with ZHUSU as(SELECT * FROM t_ga_zhusu)SELECT DISTINCT FIRST_VALUE(ID) OVER(PARTITION BY T1.CERTNO ORDER BY T1.CHECINTIME DESC NULLS LAST, T1.ID DESC) ID, (select count(1原创 2016-01-29 13:10:44 · 218 阅读 · 0 评论 -
oracle新增(ibatis)
insert into upload_files_type(id,name,pid,type,orderVal)values(SQ_UPLOAD_FILES_TYPE.nextval,#name#,#pId#,#type#,#orderVal#)selectSQ_UPLOAD_FILES_TYPE.currval as id from原创 2015-12-14 15:39:46 · 151 阅读 · 0 评论 -
oracle锁
SELECT A.OWNER, --OBJECT所属用户 A.OBJECT_NAME, --OBJECT名称(表名) B.XIDUSN, B.XIDSLOT, B.XIDSQN, B.SESSION_ID, --锁表用户的session B.原创 2015-12-14 14:11:27 · 191 阅读 · 0 评论 -
oracle删除恢复
SELECT * FROM t_sqjz_quesanswer AS OF TIMESTAMP(SYSTIMESTAMP - INTERVAL '1' DAY)原创 2015-12-14 14:15:04 · 142 阅读 · 0 评论 -
ibatis缓存
Ibatis缓存 简单使用一 缓存简单介绍 二 缓存简单使用 使用例子:cacheModelsEnabled="true" 单表组织机构: cacheModel type="LRU" id="organCache">flushInterval minutes="30" />flushOn原创 2015-12-14 17:22:39 · 232 阅读 · 0 评论 -
oracle之function
CREATE OR REPLACE FUNCTION SELECT_CURSTARTANDEND(SELECTDATE IN DATE) RETURN RESULT_T_CURSTARTANDEND PIPELINED ISBEGIN PIPE ROW(RESULT_CURSTARTANDEND( trunc(SELECTDATE,'mm') , t原创 2016-06-15 09:54:08 · 208 阅读 · 0 评论