OUTER JOIN with Sub Query
- in SQL
When you are creating a SubQuery (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 statement,…
Month: February 2018
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…
Multiple rows into a comma delimited list in PL/SQL
- in SQL
Multiple rows One common thing to request is data from multiple rows into a comma delimited list in PL/SQL. If you are using Oracle 11g or greater there are a couple of options. The first…