#sqlmacro wyniki wyszukiwania

-- @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; /

FranckPachot's tweet image. -- @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;
/

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

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

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-another…

Andrej_SQL's tweet image. 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-another…

Yet another way starting with 19.6 is to use a #SQLmacro. blog.sqlora.com/en/yet-another…

It's not one of mine, but I've just published a very old version of Tom Kyte's print_table() that I've been using for the last 19 years: jonathanlewis.wordpress.com/2020/11/26/pri…



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-macros-…


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-macros-…


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

robycapancioni's tweet image. 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; /

FranckPachot's tweet image. -- @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-another…

Andrej_SQL's tweet image. 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-another…

Yet another way starting with 19.6 is to use a #SQLmacro. blog.sqlora.com/en/yet-another…

It's not one of mine, but I've just published a very old version of Tom Kyte's print_table() that I've been using for the last 19 years: jonathanlewis.wordpress.com/2020/11/26/pri…



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

robycapancioni's tweet image. 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; /

FranckPachot's tweet image. -- @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-another…

Andrej_SQL's tweet image. 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-another…

Loading...

Something went wrong.


Something went wrong.


United States Trends