#sqlmacros search results

Oh and what I've missed to share so far: I will be speaking about SQL macros at the #DOAG2024-Conference in November in Nuremberg. Thank you @DOAGeV for accepting my talk. See you there! #sqlmacros #oracledatabase #sql @oracleace

And the second one about SQM and the WITH clause: blog.sqlora.com/en/sql-macros-… #sqlmacros #oracledatabase #sql

Looking at the trace output for SQM expansion can help to interpret some error messages and perhaps understand some of the limitations. Two new blog posts about this: blog.sqlora.com/en/sql-macros-… #sqlmacros #oracledatabase #sql @oracleace

Thanks @DOAGeV and organizing team for this awesome 10th #apexconn24 conference. And thanks to all attendies for your attention and feedback. I hope @josifabr and I could convince a few more people to check out #sqlmacros

The second part is all about using COLUMNS pseudo-operator with #SQLmacros. Did you know that you can also pass data types along with the column names? Or use it with scalar #SQLmacros? #OracleDatabase @oracleace blog.sqlora.com/en/sql-macros-…

Where can scalar #SQLmacros appear? Apparently more often than you might think. Can the #SQLmacros be nested? - Actually no, but somehow yes... @oracleace New blog post: 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-…

Still new for many users and rarely used, but no longer on the new features list of #Oracle23c. Talking again about #SQLmacros at #ittage2023 today to remind of this valuable Feature

Want to see the final SQL after applying all your #SQLmacros? Also for scalar macros? New blog post: blog.sqlora.com/en/how-to-get-…

As the documentation says, the scalar SQL macros should also work in the GROUP BY clause. But I can't get it to work. Here is the simplest example. Am I doing something wrong or is it a bug? Thanks #Oracle23c #sqlmacros @ChrisRSaxon @connor_mc_d @StewAshton

My experience asking #ChatGPT about #SQLmacros in #OracleDatabase.😀For now I would still stick to using google, oracle docs, asktom and Co., at least for the topics that are new to me. How fast will it get better, what do you think? blog.sqlora.com/en/what-does-c…

SQL Macros used in Oracle Apex { by @oraclexpert } from @hashnode #sql #oracle #sqlmacros #apex #oracleapex yaitcon.hashnode.dev/sql-macros-use…

A second post today - finding frequency-based ranges for various tables (e.g., user_scheduler_job_run_details) with #PatterMatching and #SQLMacros db-oriented.com/2022/07/30/fre… @OracleDatabase #orcldb #21c #SQL @oracleace #ACED

a bunch of collection for #sql and #pl/sql with many new and useful things over different @OracleDatabase releases especially with #sqlmacros and #polymorphic things. very cool Winkende Hand

Day 2 session 2 of #ausougConnect21 with @ChrisRSaxon and #sqlMacros We are LIVE now but registrations are still opened attendee.gotowebinar.com/register/65114… #oracle #sql #plsql

Next lined up is @ChrisRSaxon on #ausougConnect21 DEV day talking about #SQLmacros Registrations are welcomed and still opened at register.gotowebinar.com/register/65114… #oraclesql #oracle

@ChrisRSaxon and @sfonplsql had a great time yesterday on #Feuertips 24, as Chris demoed Oracle's new #SQLmacros feature. See the recording and check out the reference links too! #PLSQL insum.ca/feuertip-24-th…

Thank you @DOAGeV for accepting my talk about #SQLmacros for the #apexconn21! Looking forward to "see you there"

Happy New Year! In case you missed it over the holidays: two new use cases of #SQLmacros added to the collection: 1/2: blog.sqlora.com/en/yet-another…

I see no reason to restrict to scalar queries. Moreover, the use of the scalar #SQLmacros in HAVING clause is explicitly documented and it is especially there that aggregates will make sense...

When using views or subqueries as input for #PTF or table #SQLmacros, you might hit ORA-62558. Do you think it's a bug? Should the cast from external DATE (Typ=13) to internal (Typ=12) be made internally and transparent for the user? @ChrisRSaxon @connor_mc_d

Same story with my submission but with a bit less luck: now I'm on a waiting list with my talk about #SQLMacros Using a table SQL macro function, you can just add a record to whatever table you're querying. Exactly what I need now😀

Thanks @DOAGeV for accepting my talk for the virtual conference #DOAG2020. I will talk about #SQLMacros on Tuesday, November 17 at 16:00.

Thank you @DOAGeV for accepting my talk about #SQLmacros for the #apexconn21! Looking forward to "see you there"

As the documentation says, the scalar SQL macros should also work in the GROUP BY clause. But I can't get it to work. Here is the simplest example. Am I doing something wrong or is it a bug? Thanks #Oracle23c #sqlmacros @ChrisRSaxon @connor_mc_d @StewAshton

Oh and what I've missed to share so far: I will be speaking about SQL macros at the #DOAG2024-Conference in November in Nuremberg. Thank you @DOAGeV for accepting my talk. See you there! #sqlmacros #oracledatabase #sql @oracleace

Join me for my virtual session at #UKOUGConf20 on Wednesday 2 December 14:00-14:45. I’ll be presenting on #SQLmacros: bit.ly/2IM4Ykc @UKOUG

Thanks @DOAGeV and organizing team for this awesome 10th #apexconn24 conference. And thanks to all attendies for your attention and feedback. I hope @josifabr and I could convince a few more people to check out #sqlmacros

Next lined up is @ChrisRSaxon on #ausougConnect21 DEV day talking about #SQLmacros Registrations are welcomed and still opened at register.gotowebinar.com/register/65114… #oraclesql #oracle

Still new for many users and rarely used, but no longer on the new features list of #Oracle23c. Talking again about #SQLmacros at #ittage2023 today to remind of this valuable Feature

Day 2 session 2 of #ausougConnect21 with @ChrisRSaxon and #sqlMacros We are LIVE now but registrations are still opened attendee.gotowebinar.com/register/65114… #oracle #sql #plsql