Oracle Apps

When a query is submitted to the database, it is executed in the following order: FROM clause WHERE clause GROUP BY clause HAVING cla...

Table index is one of the most important areas, while optimizing a query. Here is the best practice of using these indexes, to get the...

Step1 :  Run the first query ,  this will list all the programs that currently running in Application. Take the SID and use it in the second...

SQL to identify the query which takes long time Sequence of SQL query processed