I am running an Oracle 11G with Apex 4.2.6. Im trying to run a script, but giving back nulls in the top but showing the correct result in SQL Developer
Select "ENG_ID", "ENG_ID1", "roles", "field "," 3 "," 4 "," 5 "," 6 "," 7 "," 8 "," 9 "," 10 "," 11 "," 12 " "13", "21", "22", "23", "24", "25", "13", "16", "17", "18", "19", "20", "21" Choose from "26", "28", "29", "30", "31" ("Roles" as ENG_ID as M.ENG_ID, M.ENG_ID ENG_ID1, e.ROLE_ID, Then e.REGION_AREA_ID as "field", extract (DAY from M.MS_DATE), MD_TS_DETAIL MD to MD.MD_ID --MD.JOB_TYPE_ID, MD_TS_MAST M, as MAN_ENGINEERS E Yes m.eng_id = 542 and m.ENG_ID = e.ENG_ID and M.MAST_ID = MD.MD_ID and M.MS_DATE TRUNC (sysdate, 'mm') and LAST_DAY (sysdate)) axis (max (MD_ID) Between (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23, 24,25,26,27,28,29,30,31)) Which gives me the correct result
SQL Dev View
Yet within the epics there is only one script running, you get the tap.
Supreme view.
I am totally stumped. Do you have any thoughts with friends?
After examining whether there are maximum records where both record and both APEX and database directly on. . In the SQL Workshop> Selected MD_TS_MAST> Statistics> Analyze> Reform Assessments to 100%> Next> Finish
All records come back. If I do not know why the highest database was not run directly from the database, basically if the SQL Developer is inspecting, then you have to update through the analysis.
Comments
Post a Comment