Introduced in a basic form in 18c and fully matured in 19c, PTFs are a powerful type of table function. They accept a table as an input argument and return a table whose column structure is determined dynamically at runtime. This allows for highly dynamic data transformations and custom analytical processing within SQL.
: You can now use the DISTINCT keyword directly within the LISTAGG function to remove duplicate values from a concatenated list. oracle sql 19c pdf new
While 19c is largely about stability and automation, it introduced several significant enhancements: Introduced in a basic form in 18c and
If a SQL statement consumes excessive resources (CPU/IO) and exceeds established thresholds, the Resource Manager can automatically quarantine it. oracle sql 19c pdf new