Tag: json_table

Database Pipes have been around in Oracle Database since release 7. In memory, light weight, non-persistent, fast and a little low level. Somewhat brittle: the contents of a pipe …

A simple challenge: I am working on a SQL query. Not a trivial query. I am trying various approaches. I believe I may have found a solution that works. …

One of those things SQL developers are frequently looking at is the generation of rows: having a query return records that do not really exist. For example to generate …