从执行块中选择? [英] Select from execute block?

问题描述

是否可以从执行块结果中进行选择?我想从中执行一些操作(求和等).

Is is possible to select from execute block result? I want to perform some operation (sum etc..) from it.

 select t1.* 
 from 
   ( execute block 
     returns ( 
       OUT_VALUE integer ) 
    as 
    begin 
    ... 
    suspend; 
  end ) t1

或

 with   
 t1 as ( execute block ... ) 
   select * 
   from t1 
   order by 
     t1.sort_column 

两者都不起作用.有人有建议吗?谢谢！

Neither does not work. Anyone has an advice? Thanks!

推荐答案

您应该创建一个独立的存储过程，例如

You should create an independent stored procedure like

create procedure proc1
returns (
  OUT_VALUE integer 
) as
begin
   ... 
  suspend; 
end

，然后选择此过程

select sum(OUT_VALUE)
from proc1

这篇关于从执行块中选择?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！