Posts
Showing posts from April, 2021
display first day of the month between two dates
- Get link
- X
- Other Apps
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
- Get link
- X
- Other Apps
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