Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- EXECUTE IMMEDIATE 'select count(*) FROM (select distinct * from ' || t || ' where ' || c || ' is not null)' INTO notnulldistinctcount;
- EXECUTE IMMEDIATE 'SELECT COUNT(*) FROM ' || t || ' WHERE ' || c || ' is not null' INTO notnullcount;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement