Need help with Oracle Stored Procedure
Posted on 2007-08-02
I am trying to find out the each field count in table where the field is Null.So below is the script I am using but when I excute this procedure in SQL Plus its just saying
PL/SQL procedure successfully completed.
But its not displaying any results.
What do I need to change in the script to see the results and do you think my script is good enough to get the results I am looking for?
CREATE OR REPLACE PROCEDURE FieldCount AS
for r1 in (select table_name,column_name from all_tab_columns where owner='AMI' and table_name='PROVIDER') LOOP
'Begin select count(1) into :1 from '||r1.table_name||'
where '||r1.column_name||' is null;end;'
using in out v_cnt;