12.2

Oracle 12cR2 SQL new feature: LISTAGG overflow

By Franck Pachot . LISTAGG was a great feature introduced in 11g: put rows into line with a simple aggregate function. 12cR2 adds an overflow clause to it. What happens when you have so many rows that the LISTAGG(…)

Question is: upgrade now to 12.1.0.2 or wait for 12.2 ?

By Franck Pachot . Let's look at Release Schedule of Current Database Releases (Doc ID 742060.1) 12.2.0.1 is planned for 2HCY2016 on platforms Linux x86-64, Oracle Solaris SPARC (64-bit), Oracle Solaris x86-64 (64-bit). 2HCY2016 starts next(…)

You are in Standard Edition One? Don’t worry.

By Franck Pachot . You want the amazing features of Oracle SQL and PL/SQL with minimal cost. Your database is too large for Oracle XE edition, but not big enough to require the cost of Enterprise Edition. You accept to(…)