Top Tweets for #SQLMacros
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
https://t.co/0QmVMZ3zB3
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:
https://t.co/6688Sd2Gtb
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?
https://t.co/5RlXuiqT1q
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
Already available since @OracleDatabase 21c, but still new for many people in the audience: SQL Macros, explained by @Andrej_SQL at #DOAG2023
Want to see the final SQL after applying all your #SQLmacros? Also for scalar macros?
New blog post:
https://t.co/jWLazGLdwZ
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?
https://t.co/8TQZrVm0dM
SQL Macros used in Oracle Apex
{ by @oraclexpert } from @hashnode
#sql #oracle #sqlmacros #apex #oracleapex https://t.co/TipYNiofCG
A second post today -
finding frequency-based ranges for various tables (e.g., user_scheduler_job_run_details) with #PatterMatching and #SQLMacros
https://t.co/R9w1tFHA7J
@OracleDatabase #orcldb #21c #SQL @oracleace #ACED
Day 2 session 2 of #ausougConnect21 with @ChrisRSaxon and #sqlMacros
We are LIVE now but registrations are still opened
https://t.co/dEGiWk54km
#oracle #sql #plsql
Next lined up is @ChrisRSaxon on #ausougConnect21 DEV day
talking about #SQLmacros
Registrations are welcomed and still opened at
https://t.co/UCs9O3Idcz
#oraclesql #oracle
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: https://t.co/EXFKk0vzmt @oracleace @HeyAlfredoDBA @odtug @orclDBblogs
@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
https://t.co/mGqezdZzwe
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:
https://t.co/TUshy6lMcx
@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...
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 ๐
https://t.co/9jiQpn56Yx
Join me for my virtual session at #UKOUGConf20 on
Wednesday 2 December 14:00-14:45. Iโll be presenting on #SQLmacros: https://t.co/cnSvC8wiBn
@UKOUG
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
Trends for you
Most Popular Users
Elon Musk 
@elonmusk
241.5M followers
Barack Obama
@barackobama
118.9M followers
Cristiano Ronaldo
@cristiano
114.6M followers
Donald J. Trump
@realdonaldtrump
111.8M followers
Narendra Modi
@narendramodi
107.1M followers
Rihanna
@rihanna
98.7M followers
NASA
@nasa
92.3M followers
Justin Bieber
@justinbieber
91.8M followers
KATY PERRY
@katyperry
90M followers
Taylor Swift
@taylorswift13
84M followers
Lady Gaga
@ladygaga
75.5M followers
Virat Kohli
@imvkohli
73.5M followers
Kim Kardashian
@kimkardashian
70.9M followers
YouTube
@youtube
68.8M followers
Neymar Jr
@neymarjr
66.5M followers
Bill Gates
@billgates
65.2M followers
Selena Gomez
@selenagomez
63.1M followers
The Ellen Show
@theellenshow
62.2M followers
CNN
@cnn
61.8M followers
X
@x
60.7M followers