熱點推薦:
您现在的位置: 電腦知識網 >> 編程 >> Oracle >> 正文

在存儲過程中做簡單動態查詢代碼

2013-11-13 15:30:19  來源: Oracle 

  CREATE OR REPLACE procedure ZXM_SB_GZ_GET
  (p_table in varchar
  p_name in varchar
  p_value in varchar
  outpara out lntxdbazxm_pag_cs_powerc_type
  )
  as
  begin
  declare
  wherevalue varchar();
  begin
  wherevalue:=select * from ||p_table|| where ||p_name||=||p_value;
  open outpara for
  wherevalue;
  end;
  end;
From:http://tw.wingwit.com/Article/program/Oracle/201311/16822.html
    推薦文章
    Copyright © 2005-2013 電腦知識網 Computer Knowledge   All rights reserved.