24 Apr 2024
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
2
8
366
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-macroβ¦
1
5
298
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-macroβ¦
2
5
367
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
13 Dec 2023
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
22 Nov 2023
Already available since @OracleDatabase 21c, but still new for many people in the audience: SQL Macros, explained by @Andrej_SQL at #DOAG2023
4
317
Want to see the final SQL after applying all your #SQLmacros? Also for scalar macros?
New blog post:
blog.sqlora.com/en/how-to-geβ¦
2
5
358
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
4
5
1,267
26 Mar 2023
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β¦
2
246
19 Feb 2023
SQL Macros used in Oracle Apex
{ by @oraclexpert } from @hashnode
#sql #oracle #sqlmacros #apex #oracleapex yaitcon.hashnode.dev/sql-macβ¦
1
6
18
1,945
30 Jul 2022
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/fβ¦
@OracleDatabase #orcldb #21c #SQL @oracleace #ACED
1
4
12
9 Nov 2021
Day 2 session 2 of #ausougConnect21 with @ChrisRSaxon and #sqlMacros
We are LIVE now but registrations are still opened
attendee.gotowebinar.com/regβ¦
#oracle #sql #plsql
1
3
Next lined up is @ChrisRSaxon on #ausougConnect21 DEV day
talking about #SQLmacros
Registrations are welcomed and still opened at
register.gotowebinar.com/regβ¦
#oraclesql #oracle
2
2
3 Sep 2021
Learn a little more about Oracle SQL Macros with my @odtug TechCeleration article.
#oracle #development #sqlmacros
#OrclDB TechCelerationβs newest blog βOracle SQL Macros: Simplicity and Performance for Allβ by #Oracle ACE Alfredo Abate is here! Read the full article: bit.ly/3nb4S @oracleace @HeyAlfredoDBA @odtug @orclDBblogs
3
@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-the-powβ¦
1
8
26 Mar 2021
Thank you @DOAGeV for accepting my talk about #SQLmacros for the #apexconn21! Looking forward to "see you there"
1
4
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-anothβ¦
1
2
3
28 Dec 2020
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...
2
23 Dec 2020
The last blog post about #SQLmacros, well this year π
Using UNPIVOT and GROUP BY to find out what columns are different in almost identical rows.
Of course, as a SQL macro π
blog.sqlora.com/en/comparingβ¦
1
8
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
2
4
16 Nov 2020
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
1
9