Posts

Showing posts from April, 2021

Inventory organization period open

Image
 

display first day of the month between two dates

SELECT   TO_CHAR (R_MONTH, 'dd/mm/yyyy') MONTH   FROM   (  SELECT   ADD_MONTHS (TO_DATE ('12-2020', 'mm-yyyy'), ROWNUM - 1)                         R_MONTH               FROM   DBA_OBJECTS              WHERE   ROWNUM <=                         MONTHS_BETWEEN (                            TO_DATE ('01-2021', 'mm-yyyy'),                            ADD_MONTHS (TO_DATE ('12-2020', 'mm-yyyy'), -1)                         )           ORDER BY   R_MONTH); ------------------------------------------------------ insert into fiscal_M select * from ( SELECT TO_CHAR(WHICH_MONTH, 'yyyymm') fiscal_MONTH_TXT,trunc(WHICH_MONTH) DAT,'2020' YAR,TO_CHAR(WHICH_MONTH, 'Mon-yyyy') YAR_MM FROM ( SELECT ADD_MONTHS(TO_DATE('07-2021','mm-yyyy'), ROWNUM-1) WHICH_MONTH FROM DBA_OBJECTS WHERE ROWNUM <= MONTHS_BETWEEN(TO_DATE('06-2022','mm-yyyy'), ADD_MONTHS(TO_DATE('07-2021','mm-yyyy'

Command Prompt /CMD /Windows Terminal

             Dir 2.        Cls 3.        Color 0A 4.        Color /? 5.        color 6.        Dir/a 7.        Cd directoryName 8.        Cd .. 9.        Cd ../.. 10.    Mkdir 11.    Rmdir 12.    Rmdir /s directoryName 13.    echo >a.txt 14.    echo sabuj > a.txt 15.    echo ahamed >> a.txt 16.    a.txt 17.    echo software > b.txt 18.    copy a.txt b.txt 19.    move b.txt c.txt 20.    dir >> b.txt 21.    del b.txt 22.    type a.txt 23.    Ctrl + left or right arrow to jump word to word 24.    move directoryName(Dhaka) directoryName (Bangladesh) 25.    dir *.txt 26.    dir *.png 27.    wmic logicaldisk get name 28.    tree 29.    ipconfig/? 30.    Ipconfig/all

Transaction Open Interface

Image