“Now I am getting 9 rows” The outer loop steps through an array of three elements. The nested loop steps through an array of three elements for every element in the outer loop. 3 * 3 = 9. “how to get ‘AA’ ‘BB’ ‘CC’ from below query” Apply Occam’s razor and discard the inner loop: … Read more
You said: “Did Oracle EBS has a feature to sent an email at the pre-registered email address “. Do you mean workflow notification mailer? The EBS is managed using apps user. If apps user is locked then the whole EBS would be down. 3 solved oracle account lockout status
How to get first three characters of a string and last three character of the same string in oracle, and display them, what will be the query? solved How to get first three characters of a string and last three character of the same string in oracle, and display them, what will be the query?
Better to understand DBMS_SQL itself to some extent, before understanding NUMBER_TABLE. ( I do this for My Learning!) NUMBER_TABLE is Actually, TYPE number_table IS TABLE OF NUMBER INDEX BY BINARY_INTEGER; So, only numbers are allowed! FlowChart on How DBMS_SQL Works! : Your interested area comes in bind variable box — | open_cursor | — ———– … Read more
Now that I understand your issue, just subtract the 2 dates to determine the time frame difference: SELECT S.Id, S.Start_dt, S.End_dt, S.Division FROM Sample S JOIN ( SELECT S.Id, Max(S.end_dt-S.start_dt) as timeframe FROM Sample S GROUP BY S.Id ) S2 ON S.Id = S2.Id AND S.end_dt-S.start_dt = s2.timeframe Here is the Fiddle. Good luck. 3 … Read more