ORACLE中存储过程的疑问
v_SQL := ' INSERT INTO wuxianglai.BAOJIANHUI_KEYVALUE(KEMU,JIGOU,VALUE1,VALUE2,YEAR,MONTH) ' ||
' SELECT a.KEMU,a.JIGOU,a.VALUE1,SUM(nvl(b.KeyValue,0)), ' || p_year || ',' || p_month ||
' FROM wuxianglai.BAOJIANHUI_SHUJU b,wuxianglai.BAOJIANHUI_TMPKEYVALUE a ' ||
' WHERE a.JiGou = b.DIQU ' ||
' AND b.key in ' || p_KeMuDaiMa2 ||
' AND year = ' || p_year || ' and month = ' || p_month ||
' AND intervaltype = ' || p_intervaltype ||
' GROUP BY a.kemu,a.jigou,a.value1';
朋友们知道||到底什么个意思我不大明白
还有insert into后面为什么不跟values是不是oracle中可以这样写
谁能给我注释下这段代码要表面什么个意思马上结贴!!