oracle
文章平均质量分 77
whatisjavajob
这个作者很懒,什么都没留下…
展开
-
oracle拆分字符串
PROCEDURE HAND_MID_SYS_BPM_USE_ROLE(IORGTYPE IN BPM_COMPSITE_USER.ORGTYPE%TYPE, IDATE IN DATE) IS V_ORGTYPE BPM_COMPSITE_USER.ORGTYPE%TYPE := IORGTYP原创 2015-10-28 14:55:24 · 189 阅读 · 0 评论 -
MERGE 用法
MERGE INTO SYS_USER_POS PS USING (SELECT U.USERID, M.ORG_ID, M.POS_ID FROM SYS_USER U INNER JOIN MID_SYS_USER_PMP_SYNC M ON U.ACCOUNT = M.ACCOUNT WHERE M.CHECK_STATUS = '0')原创 2015-10-28 15:00:31 · 354 阅读 · 0 评论 -
oracle-update双表问题
update temp1 a set (a.fullname) = (select first_name from temp2 b where a.account = b.emp_num and rownum = 1) where原创 2016-01-18 13:47:36 · 346 阅读 · 0 评论