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;

/

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

Search files in Unix which doesn't contain specific Text

Simple Grep command to search all files in a directory 

grep -RiL "Text to search" <Directory to be searched>

Grep command with Find together, searching only those file names which doesn't have a specific text.

find . -name *.automationTask | xargs grep -RiL "sendNullMessage" ;

find . -iname "*.txt" -exec grep -Li "mystring" {} \+

Connect to SQL in Command

 sqlplus user/pass@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(Host=hostname.network)(Port=1521))(CONNECT_DATA=(SID=remote_SID)))

Unix : Empty Log files

For multiple files you can use wildcard, example: 

truncate -s 0 /dir/log/*log 

For nested folders: 

truncate -s 0 /dir/log/**/*.log

Zoom meeting save Conf and Pwd

Batch File

My first attempt involved setting up a batch file. I created a plain text file and renamed it meeting.bat. I did some digging online and figured out the command to use was:

start "" "zoommtg://zoom.us/join?action=join&confno=#####&pwd=ABC123"

where ##### is replaced with the meeting ID, and ABC123 is replaced by the meeting password if one exists.

If you've got a Zoom meeting link, it will be formatted along the lines of https://zoom.us/j/123456, the 123456 at the end is the meeting ID.

Save the changes to the batch file and double-click to run.

Run a job without Crontab/Cron job

 Inorder to run a script to keep on running in active window

countdown()
(
  IFS=:
  set -- $*
  secs=$(( ${1#0} * 3600 + ${2#0} * 60 + ${3#0} ))
  while [ $secs -gt 0 ]
  do
    sleep 1 &
    printf "\r%02d:%02d:%02d" $((secs/3600)) $(( (secs/60)%60)) $((secs%60))
    secs=$(( $secs - 1 ))
    wait
  done
  echo
)
while true; do nj_cc ; echo "----Sleeping----"; countdown "00:10:00" ; clear ; done