HAN_789的博客

备注：添加索引之后验证索引有效性： 执行1：EXPLAIN PLAN FOR select accouts, accrate, completeratio, def1, def10, def11, def12, def13, def14, def15, def16, def17, def18, def19, def2, def20, def3, def4, def5, def6, def7, def8, def9, isdeposit, isprepayment, memo, oprnum, payme

有一个树形结构id,pid,name现有需求需要查询id在pid下的排列顺序 不了解oracle函数之前最开始的写法是这样的: SELECT rownum AS rn, a.id FROM ( SELECT * FROM SE_REQ_ITEM_INFO WHERE PARENT_ID = ( SELECT PARENT_ID FROM SE_REQ_ITEM_INFO ...

执行计划 explainplanfor SELECTid,rnFROM(SELECTrownumASrn,a.idFROM(SELECT*FROMSE_REQ_ITEM_INFOWHEREPARENT_ID=(SELECTPARENT_IDFROMSE_REQ_ITEM_INFOWHEREID=3015)ANDDOCUMENT_ID=20ORDERBYrankingasc)a)pWHEREp.id=3010 执行计划的查...

最近遇到行转列的问题需要将同一个id下面的数据组装起来 与另一张主表中的数据组成一一条数据 sql代码如下 SELECT * FROM SE_REQ_ITEM_INFO srii LEFT JOIN ( SELECT ENTITY_ID, CASE WHEN attr_id = '201' THEN value END "201", CASE WHEN attr_id = 202 THEN value END "202", CASE WHEN attr_id = 203 THEN v