oracle的存储过程中可以用with查询吗？比如用with 查询一个结果放到一个游标内怎么做

Question

PROCEDURE COLLECT_RESULT(OUT_RESULT OUT RETURN_CURSOR)
IS
BEGIN
WITH Q1 AS (SELECT 3 + 5 S FROM DUAL),

Q2 AS (SELECT 3 * 5 M FROM DUAL),

Q3 AS (SELECT S, M, S + M, S * M FROM Q1, Q2)

OPEN OUT_RESULT FOR SELECT * FROM Q3；
END COLLECT_RESULT;

Answer 1

这么玩。
[code="sql"]
procedure COLLECT_RESULT(OUT_RESULT out MYTYPE) is
begin
open OUT_RESULT for with Q1 as(
select 3 + 5 as S
from DUAL), Q2 as (select 3 * 5 as M from DUAL), Q3 as (select S,
M,
S + M,
S * M
from Q1,
Q2)
select * from Q3;
end COLLECT_RESULT;
[/code]