Advertisement
Guest User

Untitled

a guest
Sep 21st, 2017
59
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PL/SQL 0.23 KB | None | 0 0
  1. EXECUTE IMMEDIATE 'select count(*) FROM (select distinct * from ' || t || ' where ' || c || ' is not null)' INTO notnulldistinctcount;
  2.  
  3.  EXECUTE IMMEDIATE 'SELECT COUNT(*) FROM ' || t || ' WHERE ' || c || ' is not null' INTO notnullcount;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement