Question

将这个sql语句转换成存储过程，Oracle存储过程语句

SELECT to_number(A.VALUE)-to_number(E.VALUE) AS VAL,A.NAME FROM
(
SELECT SUM (D.VALUE) AS VALUE,D.NAME FROM VIEW_MIDSCFDATA D WHERE
D.INSERTIME=TO_DATE(#{StartData},'YYYY-MM-DD HH24:MI:SS')-1 GROUP BY d.NAME
) E,(
SELECT sum(K.VALUE) AS VALUE,K.NAME FROM VIEW_MIDSCFDATA K WHERE
K.INSERTIME=TO_DATE(#{EndData},'YYYY-MM-DD HH24:MI:SS') GROUP BY k.NAME
) A
WHERE E.NAME=A.NAME

Answer 1

你是要查询，还是要插入，还是要获取这个值去做其他事情
要是就是查询的话建个视图就完事了
其他的情况再去创建存储