I have a PL/SQL block where I am trying to get the count of filled and not filled values for each column of a table i.e. "demo_table".
select count(*) into v_count from demo_table
where owner='OWNER_1' and(rec.COLUMN_NAME is null OR
REGEXP_LIKE(rec.COLUMN_NAME,'^-$') OR REGEXP_LIKE (rec.COLUMN_NAME,'^-$'));
I am displaying the v_count
through dbms_output. But I am not able to get the count.
This is what I am doing:
declare
CURSOR C1 IS
SELECT COLUMN_NAME FROM ALL_TAB_COLUMNS
WHERE TABLE_NAME ='demo_table';
v_count number(10);
begin
for rec in c1 loop
dbms_output.put_line(rec.COLUMN_NAME);
select count(*) into v_count from demo_table
where owner='OWNER_1'
and(rec.COLUMN_NAME is null
OR REGEXP_LIKE(rec.COLUMN_NAME,'^-$')
OR REGEXP_LIKE (rec.COLUMN_NAME,'^-$'));
dbms_output.put_line(v_count);
end loop;
dbms_output.put_line(v_count);
end;