Filter
Exclude
Time range
-
Near
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…
1
5
187
Check out my latest article: Creating a Dashboard in APEX using parameterized view (SQL Macro) #orclapex #sql #sqlmacro linkedin.com/pulse/creating-… via @LinkedIn
3
8
523
-- @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; /
2
2
10
2,058
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…
4