This shows you the differences between two versions of the page.
Both sides previous revision Previous revision | Last revision Both sides next revision | ||
kurs:execute_immediate [2008/11/06 13:30] mh |
kurs:execute_immediate [2014/09/10 21:22] 127.0.0.1 external edit |
||
---|---|---|---|
Line 1: | Line 1: | ||
+ | <code> | ||
+ | PROCEDURE DELETE_ROWS | ||
+ | ( p_table_name IN varchar2) | ||
+ | IS | ||
+ | statement_cursor integer; | ||
+ | rows_del number; | ||
+ | BEGIN | ||
+ | statement_cursor := dbms_sql.open_cursor; | ||
+ | dbms_sql.parse(statement_cursor, | ||
+ | 'delete from '||p_table_name, | ||
+ | dbms_sql.native); | ||
+ | rows_del := dbms_sql.execute(statement_cursor); | ||
+ | -- dbms_sql.fetch_rows | ||
+ | dbms_output.put_line('zeilen geloescht '||rows_del); | ||
+ | dbms_sql.close_cursor(statement_cursor); | ||
+ | END; -- Procedure | ||
+ | </code> | ||
+ | <code> | ||
+ | PROCEDURE COUNT_ROWS | ||
+ | ( p_table_name in varchar2 | ||
+ | ) | ||
+ | IS | ||
+ | row_count number; | ||
+ | sql_code varchar2(1000); | ||
+ | BEGIN | ||
+ | sql_code := 'select count(*) from '||p_table_name; | ||
+ | -- objekt namen koennen nicht als bind variablen verwendet werden | ||
+ | execute immediate sql_code into row_count; | ||
+ | dbms_output.put_line(p_table_name ||' contains ' | ||
+ | ||row_count||' rows'); | ||
+ | END; -- Procedure | ||
+ | </code> |