v_sql varchar2(4000);
s_cursor INTEGER;
ignore INTEGER;
v_count INTEGER;v_sql = 'select count(*) from SYS.ALL_TAB_COLUMNS where TABLE_NAME='''
|| tablename[i] ||''' and owner='HR' ';
s_cursor := dbms_sql.open_cursor;
dbms_sql.parse(s_cursor, v_sql, DBMS_SQL.v7);
dbms_sql.define_column(s_cursor, 1, v_count);
ignore := DBMS_SQL.EXECUTE(s_cursor);
loop
if dbms_sql.fetch_rows(s_cursor) > 0 then
-- get column values of the row
dbms_sql.column_value(s_cursor, 1, v_count);
else
-- no more row to copy
exit;
end if;
end loop;
DBMS_SQL.CLOSE_CURSOR(s_cursor);
s_cursor INTEGER;
ignore INTEGER;
v_count INTEGER;v_sql = 'select count(*) from SYS.ALL_TAB_COLUMNS where TABLE_NAME='''
|| tablename[i] ||''' and owner='HR' ';
s_cursor := dbms_sql.open_cursor;
dbms_sql.parse(s_cursor, v_sql, DBMS_SQL.v7);
dbms_sql.define_column(s_cursor, 1, v_count);
ignore := DBMS_SQL.EXECUTE(s_cursor);
loop
if dbms_sql.fetch_rows(s_cursor) > 0 then
-- get column values of the row
dbms_sql.column_value(s_cursor, 1, v_count);
else
-- no more row to copy
exit;
end if;
end loop;
DBMS_SQL.CLOSE_CURSOR(s_cursor);
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货