全部博文
-
编辑 删除
有关动态显示不确定表的相关列的实现
create or replace procedure dump_query( p_query in varchar2 )is l_columnValue varchar2(4000); l_status integer; l_colCnt number default 0; l_cnt number default 0; l_line long; /* We'll be using this to see how many columns * we have to fetch so we can define them and * then retrieve their values. */ l_descTbl dbms_sql.desc_tab; /* Step 1 - open cursor. */ l_theCursor integer default dbms_sql.open_cursor;begin
