Oracle BOX

 SELECT * FROM FND_USER WHERE USER_NAME='126545'

 SELECT ffm.formula_no, ffm.formula_desc1 formula_name, DECODE (fmd.line_type, 1, 'Product', 'Ingredient') TYPE, msi.segment1 icode, ood.organization_code org, fmd.qty, fmd.detail_uom, DECODE (ffm.formula_status, 700, 'Active', 'New') status FROM apps.fm_matl_dtl fmd, apps.fm_form_mst ffm, apps.mtl_system_items_b msi, apps.org_organization_definitions ood WHERE fmd.formula_id = ffm.formula_id AND (fmd.inventory_item_id = msi.inventory_item_id(+) AND fmd.organization_id = msi.organization_id(+)) AND fmd.organization_id = ood.organization_id AND fmd.line_type=1 ORDER BY formula_no, DECODE (fmd.line_type, 1, 'Product', 'Ingredient') DESC; SELECT ffm.formula_no, ffm.formula_desc1 formula_name, DECODE (fmd.line_type, 1, 'Product', 'Ingredient') TYPE, msi.segment1 icode, ood.organization_code org, fmd.qty, fmd.detail_uom, DECODE (ffm.formula_status, 700, 'Active', 'New') status FROM apps.fm_matl_dtl fmd, apps.fm_...

 

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...

             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 direc...

 

 select * FROM FM_MATL_DTL WHERE line_no=3 and RELEASE_TYPE='1'  and trunc(LAST_UPDATE_DATE)=trunc(sysdate) SELECT * FROM FM_MATL_DTL WHERE FORMULA_ID=(select FORMULA_ID FROM FM_FORM_MST WHERE FORMULA_NO='940589') AND RELEASE_TYPE='1' delete from FM_MATL_DTL WHERE FORMULALINE_ID='784760' and FORMULA_ID='65818' AND RELEASE_TYPE='1';