byevilangler的专栏

oracle查询表字段有值的字段并返回结果集 CREATE OR REPLACE Procedure Pro_a(tablename In Varchar2 , p_cur out sys_refcursor) As Cursor temp IS Select column_name From user_tab_columns WHERE table_name=Upper(tablename); v_num Number; v_cxSQL varchar2(2000); Begin v_cxSQL:=