Saturday, 23 June 2012

Passing Table Name Dynamically To Get The Results



CREATE OR REPLACE PROCEDURE check_table (p_table_name IN VARACHAR2) IS
v_cnt NUMBER(10);
TYPE TType IS REF CURSOR;
TT TType;
BEGIN
OPEN TT FOR 'SELECT COUNT(*) FROM '||p_table_name;
LOOP
FETCH TT INTO v_cnt;
EXIT WHEN TT%NOTFOUND;
DBMS_OUTPUT.put_line('count is '||v_cnt);
END LOOP;
CLOSE TT;
END check_table;

No comments:

Post a Comment