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

Many a times we come across a requirement to provide the users with a button on the Dashboard which will clear the values selected in Prompt. We can do this by a bit a scripting, lets see how we can achive this. To achive this first we need to create a button and then call [...]