UNION ALL vs UNION Oracle PL/SQL
- in SQL
UNION ALL vs UNION Oracle PL/SQL You might be wondering should I use UNION or UNION ALL in a SQL query. What is the performance difference in UNION ALL vs UNION? This should shed some…
OUTER JOIN with Sub Query
- in SQL
When you are creating a Sub Query (i.e. getting Max EFFDT and/or Max EFFSEQ) and you are using an OUTER JOIN. Instead of creating a new view and then joining the view to your SQL…
GROUP BY Clause for Oracle PL/SQL
- in SQL
GROUP BY Clause Oracle PL/SQL Normal GROUP BY A few things to remember about the GROUP BY clause for Oracle. Any fields not part of an aggregate function (i.e. MAX() , SUM() ) in the SELECT clause must be…