oracle查询表字段有值的字段并返回结果集
oracle查询表字段有值的字段并返回结果集CREATE OR REPLACE Procedure Pro_a(tablename In Varchar2 , p_cur out sys_refcursor)AsCursor temp IS Select column_name From user_tab_columns WHERE table_name=Upper(tablename);v_num Number;v_cxSQL varchar2(2000);Begin v_cxSQL:=
原创
2020-08-07 15:55:15 ·
778 阅读 ·
0 评论