Continuing with my series on table functions, I invited Chris Saxon of Oracle AskTOM fame to join us and talk about a fantastic, new-to-Oracle Database feature: SQL macros. He’ll also touch on polymorphic table functions. Here are some links to blog and resource that go into more detail. Enjoy!
SQL Macros
https://blogs.oracle.com/datawarehousing/post/sql-macros-have-arrived-in-autonomous-database
https://blogs.oracle.com/sql/post/how-to-select-the-top-n-rows-per-group-with-sql-in-oracle-database
Polymorphic table functions
https://blogs.oracle.com/oraclemagazine/how-to-dynamically-change-the-columns-in-a-sql-query
https://www.slideshare.net/ChrisSaxon1/polymorphic-table-functions-in-sql