数据管理

oracle数据管道

 

CREATE OR REPLACE PACKAGE pkg_table AS

  TYPE numset_t IS TABLE of t_gk_test%rowtype;  --定义返回类型

 

  FUNCTION get_gk_test(x varchar2) RETURN numset_t

    PIPELINED;

   

END pkg_table;

/

 

CREATE OR REPLACE PACKAGE BODY pkg_table AS

  FUNCTION get_gk_test(x varchar2) RETURN numset_t

    PIPELINED IS

  BEGIN

    --以游标方式反馈

    for c in (SELECT a.gk_id,                 

                     a.gk_code,

                     a.gk_name,

                     a.gk_data,

                     a.gk_raw

                FROM T_GK_TEST A

               WHERE A.GK_CODE = X

                  or x = '000') loop

   

      pipe row(c);

    end loop;

 

    return;

  END;

END pkg_table;

 

/