#sqlmacros arama sonuçları
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😀
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
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
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
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
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
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
My guess is true, on the subject of #SQLMacros in #OracleDB 20c: => simplifying & readability, found this now: static.rainfocus.com/oracle/oow19/s…
Always very enlightening and much fun @ChrisRSaxon See also speakerdeck.com/chrissaxon/pat… #PatternMatching #SQLMacros #ModernSQL #OracleDevLive
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
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-…
@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…
SQL Macros used in Oracle Apex { by @oraclexpert } from @hashnode #sql #oracle #sqlmacros #apex #oracleapex yaitcon.hashnode.dev/sql-macros-use…
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-…
New blog post: When using views or subqueries as input for #PTF or table #SQLmacros, you might hit ORA-62558. What is the reason and how to work around it? blog.sqlora.com/en/using-subqu…
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-r…
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
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: 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
The slides for my #UKOUGtogether21 "Write Less With More" presentation are available here: slideshare.net/secret/nX2trrh…
slideshare.net
Oren nakdimon - Write Less With More - UKOUGtogether21
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...
SQL Basics to Advance Notes 📘 To get it ✅ 1. Like and comment 'SQL' 2. Repost 🌠 3. Follow me so that, I can dm. #SQL
Images processed by SCL CMOS Camera Configurator (SC1216-0)
What's the logical order of SQL query operations? SQL Query Execution Order (Visualized). #SQL #Databases
Master SQL IN 16 pages😍: An Amazing SQL Guide That You'll Love! To get it: 1. Follow me (so I can DM you) 2. Like and retweet 3. Reply with "SQL" #SQL
SQL Basics to Advance Notes 📘 To get it ✅ 1. Like and comment 'SQL' 2. Repost 🌠 3. Follow me so that, I can dm. #SQL
Jailbroken GPT analyzing pictures is just something else lmao
SQL Aggregate Functions #SQL #100DaysOfCode #CodeNewbie #code #Coding #LearnToCode #Database #programming
Master SQL IN 16 pages😍: An Amazing SQL Guide That You'll Love! To get it: 1. Follow me (so I can DM you) 2. Like and retweet 3. Reply with "SQL" #SQL
SQL Basics to Advance Notes 📘 To get it ✅ 1. Like and comment 'SQL' 2. Repost 🌠 3. Follow me so that, I can dm. #SQL
Something went wrong.
Something went wrong.
United States Trends
- 1. New York 20.6K posts
- 2. New York 20.6K posts
- 3. $TAPIR 1,631 posts
- 4. Virginia 519K posts
- 5. Texas 218K posts
- 6. #DWTS 40.6K posts
- 7. Prop 50 177K posts
- 8. Clippers 9,375 posts
- 9. Cuomo 405K posts
- 10. Harden 9,779 posts
- 11. TURN THE VOLUME UP 17.9K posts
- 12. Ty Lue N/A
- 13. Sixers 12.9K posts
- 14. Bulls 35.9K posts
- 15. Jay Jones 100K posts
- 16. #Election2025 16K posts
- 17. Embiid 6,107 posts
- 18. Van Jones 2,201 posts
- 19. Isaiah Joe N/A
- 20. WOKE IS BACK 35K posts