#SQLmacro

Check out my latest article: Creating a Dashboard in APEX using parameterized view (SQL Macro) #orclapex #sql #sqlmacro via @LinkedIn

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?

-- @OracleDatabase #sqlmacro 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.