Explore tweets tagged as #sqlmacros
@Andrej_SQL
Andrej Pashchenko πŸ‡ΊπŸ‡¦ πŸ’™πŸ’›
5 years
Thanks @DOAGeV for accepting my talk for the virtual conference #DOAG2020. I will talk about #SQLMacros on Tuesday, November 17 at 16:00.
0
4
14
@Andrej_SQL
Andrej Pashchenko πŸ‡ΊπŸ‡¦ πŸ’™πŸ’›
5 years
@dani_schnider @DOAGeV 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πŸ˜€
1
0
3
@Andrej_SQL
Andrej Pashchenko πŸ‡ΊπŸ‡¦ πŸ’™πŸ’›
5 years
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
1
0
2
@Andrej_SQL
Andrej Pashchenko πŸ‡ΊπŸ‡¦ πŸ’™πŸ’›
5 years
Thank you @DOAGeV for accepting my talk about #SQLmacros for the #apexconn21! Looking forward to "see you there"
1
0
4
@Andrej_SQL
Andrej Pashchenko πŸ‡ΊπŸ‡¦ πŸ’™πŸ’›
5 years
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
0
3
5
@Andrej_SQL
Andrej Pashchenko πŸ‡ΊπŸ‡¦ πŸ’™πŸ’›
2 years
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
0
2
8
@Andrej_SQL
Andrej Pashchenko πŸ‡ΊπŸ‡¦ πŸ’™πŸ’›
2 years
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
0
5
@LinoSchilde
Lino Schilde
4 years
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
0
1
3
@Andrej_SQL
Andrej Pashchenko πŸ‡ΊπŸ‡¦ πŸ’™πŸ’›
1 year
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
6
0
1
@Andrej_SQL
Andrej Pashchenko πŸ‡ΊπŸ‡¦ πŸ’™πŸ’›
2 years
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
@dani_schnider
Dani Schnider (inactive)
2 years
Already available since @OracleDatabase 21c, but still new for many people in the audience: SQL Macros, explained by @Andrej_SQL at #DOAG2023
0
0
4
@FriedholdMatz
Friedhold Matz
6 years
My guess is true, on the subject of #SQLMacros in #OracleDB 20c: => simplifying & readability, found this now:
0
0
0
@jobminerin
Jobminer.in
13 years
Openings for Experienced Into Sql/macros-pune: http://t.co/7i8oBdmOJr #Jobs #India
0
0
0
@jobminerin
Jobminer.in
13 years
Openings for Experienced Into Sql/macros-pune: http://t.co/nJ2tWxMX #Jobs #India
0
0
0
@Andrej_SQL
Andrej Pashchenko πŸ‡ΊπŸ‡¦ πŸ’™πŸ’›
5 years
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
0
1
11
@bizcaf
Bizcaf Canada
16 years
ottawa.bizcaf.ca Bilingual Lotus Approach Instructor - with SQLMacros Experience Downtown Ottawa: We need so... http://tinyurl.com/yctrb5e
0
0
0
@TalanOracleTech
Talan - Oracle Technologies (formerly Insum)
4 years
@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
0
1
8
@Andrej_SQL
Andrej Pashchenko πŸ‡ΊπŸ‡¦ πŸ’™πŸ’›
5 years
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
1
0
8
@Andrej_SQL
Andrej Pashchenko πŸ‡ΊπŸ‡¦ πŸ’™πŸ’›
5 years
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? https://t.co/VRMX4BFTo8
1
0
5
@AutonomousDW
OracleADW-PM
6 years
If you dream of writing #macros using #SQL then make sure you are at #oow19, Moscone South - Room 308 12:15 PM to learn about new #SQLMacros feature - #dreamcometrue
0
2
3
@kpatenge
karinpatenge 🌈
5 years
0
0
1