oracle
immortal2512
这个作者很懒,什么都没留下…
展开
-
oracle merge使用方法
oracle merge语法 oracle merge语法merge into biz_module_apccode ousing (select * from temp_fa) non (o.biz_module_id=142 and o.apccode_id=n.apccode_id)when matched thenupdate set o.order_by=n.order_by/...原创 2009-06-10 18:02:28 · 132 阅读 · 0 评论 -
oracle 多表联合更新
需要用到exists UPDATE TBL_REALTIME_AD_USER_RPT T3 SET T3.AD_PRICE = (SELECT PRICE FROM TBL_ROTATE_AD T4 WHERE T3.AD_ID = T4.ID ...2009-06-10 18:17:14 · 60 阅读 · 0 评论 -
oracle 循环
先定义游标 CURSOR CUR IS SELECT ADMIN_NAME FROM TBL_LINK_SPECIFY_ADMIN ; OPEN CUR; LOOP FETCH CUR INTO V_ADMIN_NAME; EXIT WHEN CUR%NOTFOUND; //do anything END LOOP;...2009-06-11 12:00:18 · 81 阅读 · 0 评论 -
oracle 自定义function
CREATE OR REPLACE FUNCTION FUN_GET_LINK_SPECIFY_ADMINS(P_LINK_ID IN NUMBER)RETURN VARCHAR2 AS /*获取指定链接定向所有管理员名字,拼装成字符串输出 @CREATEDATE 2009-05-11 @AUTHOR LUJUN */ V_RETURN VARCHAR2(4000) := '';...2009-06-11 12:01:25 · 70 阅读 · 0 评论 -
oracle以分隔符来循环字符串
CREATE OR REPLACE PROCEDURE TEST(P_DETAIL_RESULT_COUNT IN VARCHAR2) AS V_DETAIL_TYPE VARCHAR2(64); V_RESULT_COUNT NUMBER(12); V_LEN NUMBER; V_LAST_POS NUMBER; V_POS NUMBER;...2010-04-21 14:12:34 · 689 阅读 · 0 评论