oracle的存储过程中使用with

procedure PRC_TEST(OUT_RESULT out sys_refcursor) 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 PRC_TEST;

返回结果是一个游标集。

 

 


版权声明:本文为liangmengbk原创文章,遵循CC 4.0 BY-SA版权协议,转载请附上原文出处链接和本声明。