01Sep
SQL Macros
By: Steven Feuerstein On: September 1, 2021 In: APEX Developer Solutions, Feuertips Comments: 0

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

Watch the full Feuertips episode here


Feuertips

Every other Wednesday at 11 am ET, I go live on YouTube and Facebook with Michelle Skamene to provide you with a not-to-be-missed PL/SQL tip and fun conversation. Sure, we record it so you can always watch later, but live is so much more rewarding!
One participant will be selected at random to choose from three organizations dedicated to the preservation of our planet and its biodiversity.
Insum will then make a donation of $25 to that group in your name.
What could be better than levelling up your PL/SQL tips and helping one of these worthy organizations? Join us every other Wednesday at 11!
Share this:
Share

Leave reply:

Your email address will not be published. Required fields are marked *