4*4 Helper

Last 2 Edge pieces

UW => Top 2 rows to be rotated.

Rules : Unsolved edge pieces to be in same Rows with same color

Face the cube in such a way, both Unsolved edges to be kept on right side.

UW←

R↑, U←, R↓

F↻ (Clockwise),R↓,F↺ (Anti-Clockwise)

R↑,UW→

OLL Parity (Final Row + is not formed - 3 Edges are set except one Edge in Top Row For eg : Yellow last layer)

R or L => Block of 2 Columns to be rotated

U => Single Row to be rotated

X => Rotate the whole cube one time, Yellow facing away from you.

R↑ U2, X, R↑ U2, R↑ U2

R↓ U2,L↓ U2,R↓ U2

R↑ U2,

R↓ U2,R↓ U2

PLL Parity ( 2 Corners not solved)

r => 3rd column to be rotated

U => Top Row to be rotated

UW => Top 2 Rows to be rotated

r2, U2

r2, UW2

r2, UW2

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.