Wednesday, August 13, 2025

Oracle DB All Table rows count

SET SERVEROUTPUT ON; 

DECLARE

    v_table_name VARCHAR2(128);

    v_row_count NUMBER;

BEGIN

    DBMS_OUTPUT.PUT_LINE('TableName#RowsCount');

--owner is schema name

    FOR t IN (SELECT table_name FROM all_tables WHERE owner = 'PROD_ORDERMGMT' and (table_name like 'BTC%' or table_name like 'OM_%')) LOOP

        v_table_name := t.table_name;

        EXECUTE IMMEDIATE 'SELECT COUNT(1) FROM ' || v_table_name INTO v_row_count;

        DBMS_OUTPUT.PUT_LINE(v_table_name ||'#'|| v_row_count);

    END LOOP;

END;

/

Sunday, February 9, 2025

Grep text with output as Filename and its count.

 njgrep()
{
if [ $# -eq 0 ] 
then 
echo "Usage: njgrep <Txt to Search> <File Extension>";
elif [ $# -eq 1 ]
then "Only one Argument";
elif [ $# -eq 2 ]
then 
grep -l $1 *.*$2* | xargs grep -c $1;
else 
echo "$# Usage: nj_copy filename [filename]";
fi
}


Testing :
$njgrep "Fallout" out