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 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!
Speaking of rewards, Steven finishes each show with a quick quiz to see if you were listening. Participation, of course, is optional!
One lucky quiz answerer will be selected at random to choose from three organizations dedicated to the preservation of our planet and its biodiversity: The Sheldrick Wildlife Trust, The Center for Biological Diversity, and Earthwatch.
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 Wednesdays at 11!
Share this:
Share

Leave reply:

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