Search results for #SQLmacros
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
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 https://t.co/R7foefz1M5
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
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
Learn a little more about Oracle SQL Macros with my @odtug TechCeleration article. #oracle #development #sqlmacros
Learn a little more about Oracle SQL Macros with my @odtug TechCeleration article. #oracle #development #sqlmacros
@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"
@StewAshton @connor_mc_d @ChrisRSaxon 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...
I have just finished the slides for my talk about #sqlmacros tomorrow at #DOAG2020! And just in time the other good news came: I will speak again in two weeks! Thanks @UKOUG for accepting my talk for #UKOUGConf20 #oracledatabase #sqlmacros