Hi Friends, Yesterday, I was working on some issue and had to make use of Rank and Dense Rank in some reports in OBIEE. Here I am sharing the same with you as I think this might help some of you. First of all lets understand what is Rank and Dense Rank. Let me explain [...]

 MERGE JOIN: Oracle performs a join between two sets of row data using the merge join algorithm. The inputs are two separate sets of row data. Output is the results of the join.  Oracle reads rows from both inputs in an alternating fashion and merges together matching rows in order to generate output. The two [...]