![](https://img-blog.csdnimg.cn/20201014180756754.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
PL/SQL
iteye_10196
这个作者很懒,什么都没留下…
展开
-
根据某些字段合并几条记录
================================================= SELECT SUBSTR(MAX (SYS_CONNECT_BY_PATH (SCH_CD, ', ' )), 2 ) SCH_CD FROM (SELECT SCH_CD, RNC, LAG(RNC)...2008-12-30 12:59:10 · 102 阅读 · 0 评论 -
sql效率
explain plan for SELECT A.EXAM_YR, A.INDEX_NO, C.LANG_MED_CD, C.SUBJ_CD, E.ALPHA_GRADE, E.NUM_GRADE FROM XE_RP_CDDT_REG A, XE_EXAM_GRADES B, XE_SUBJ_CONFIGURATION C, XE_EXAM_CONFIGURATION D, XE_GRAD...2008-12-31 13:51:38 · 91 阅读 · 0 评论 -
ORDER BY 的时候不能在select 句子中用sequence
SELECT seq_com_id.NEXTVAL delta_id,XX.* FROM ( SELECT 'EXT' delta_type, NULL paper_no, 'D10041' err_cd, 'SYSTEM' created_by, SYSDATE created_dt, 'SYSTEM' updated_by, S...2008-10-25 15:45:08 · 404 阅读 · 0 评论