One of my New Year's Resolutions is to start writing not only about #SQLmacros. Failed today.😀But 363 attempts are still left 😅 New blog post: What else can you see in the #CBO trace about #SQLmacro expansion? blog.sqlora.com/en/sql-macro…

Check out my latest article: Creating a Dashboard in APEX using parameterized view (SQL Macro) #orclapex #sql #sqlmacro linkedin.com/pulse/creating-… via @LinkedIn

-- @OracleDatabase #sqlmacro dbfiddle.uk/S7QYik_g create function generate_series( "start" in int, "stop" in int ) return varchar2 SQL_MACRO(TABLE) as begin return 'select to_number(column_value) as generate_series from xmltable('''||"start"||' to '||"stop"||''')'; end; /

New blog post: Using a #SQLmacro with #UNPIVOT operator under the hood to return the query result as key-value pairs. blog.sqlora.com/en/yet-anoth…