Monika Lewandowska
@monikalewandowska.bsky.social
๐ค 323
๐ฅ 211
๐ 112
๐ฎOracle Witch โ ๏ธ Oracle ACE Pro ๐ฉโ๐ซTrainer ๐how2ora-en.blogspot.com
๐ป SQuizL 14-OCT-25 2/6 guesses 111 seconds ๐ฉ๐ฉ๐ฉ๐ฉ๐ฉ๐ฉโฌ ๐ฉ๐ฉ๐ฉ๐ฉ๐ฉ๐ฉ๐ฉ
bit.ly/SQuizL-game
hashtag#SQuizL hashtag#SQL
loading . . .
https://bit.ly/SQuizL-game
about 1 month ago
0
1
0
Speed SQL results for quiz on 10-OCT-2025 Attempt #1: 9 correct in 53 seconds โ โ โ โ โ โ โ โ โ โ
#SpeedSQL
devgym.oracle.com/pls/apex/f?p...
loading . . .
https://devgym.oracle.com/pls/apex/f?p=10001:5000
about 1 month ago
0
1
0
I'm over the moon :D SQuizL 10-OCT-25 1/6 guesses 27 seconds ๐ฉ๐ฆ๐ฉ๐ฉ๐ฉ๐ฉ๐ฉ
bit.ly/SQuizL-game
#SQuizL
#SQL
loading . . .
https://bit.ly/SQuizL-game
about 1 month ago
1
2
0
[PL] Krรณtki przewodnik jak zainstalowaฤ docker na Windows dla Erika.
tinyurl.com/bdexn3cr
[EN] Quick Docker Installation Guide on Windows for Erik
tinyurl.com/mwj2x643
loading . . .
Krรณtki przewodnik instalacji dockera na Windows dla Erika.
Projektowanie i programowanie baz danych Oracle. Optymalizacja, Jakoลฤ.
https://tinyurl.com/bdexn3cr
about 2 months ago
0
1
1
Speed SQL results for quiz on 08-OCT-2025 Attempt #1: 10 correct in 41 seconds โ โ โ โ โ โ โ โ โ โ
#SpeedSQL
devgym.oracle.com/pls/apex/f?p...
loading . . .
https://devgym.oracle.com/pls/apex/f?p=10001:5000
about 2 months ago
0
1
0
๐ฉบ SQuizL 08-OCT-25 1/6 guesses 136 seconds ๐ฉ๐ฉ๐ฆ๐ฉ๐ฉ๐ฉ๐ฉ
bit.ly/SQuizL-game
#SQuizL
#SQL
loading . . .
https://bit.ly/SQuizL-game
about 2 months ago
0
2
0
speed sql - I love it! Speed SQL results for quiz on 07-OCT-2025 Attempt #1: 10 correct in 43 seconds โ โ โ โ โ โ โ โ โ โ
#SpeedSQL
devgym.oracle.com/pls/apex/f?p...
loading . . .
https://devgym.oracle.com/pls/apex/f?p=10001:5000
about 2 months ago
0
1
1
SQuizL 07-OCT-25 1/6 guesses 133 seconds ๐ฉ๐ฉ๐ฉ๐ฉ๐ฉ๐ฆ๐ฉ
bit.ly/SQuizL-game
#SQuizL
#SQL
loading . . .
https://bit.ly/SQuizL-game
about 2 months ago
0
2
0
More fun to start a week... Speed SQL results for quiz on 06-OCT-2025 Attempt #1: 9 correct in 42 seconds โ โ โ โ โ โ โ โ โ โ
#SpeedSQL
devgym.oracle.com/pls/apex/f?p...
loading . . .
https://devgym.oracle.com/pls/apex/f?p=10001:5000
about 2 months ago
0
0
0
hm...Monday. SQuizL 06-OCT-25 1/6 guesses 262 seconds ๐ฉ๐ฉ๐ฉ๐ฉ๐ฉ๐ฉ๐ฉ
bit.ly/SQuizL-game
#SQuizL
#SQL
loading . . .
https://bit.ly/SQuizL-game
about 2 months ago
0
1
0
A great way to kick off the weekend <3 SQuizL 04-OCT-25 1/6 guesses 85 seconds ๐ฉ๐ฉ๐ฉ๐ฉ๐ฉ๐ฉ๐ฉ
bit.ly/SQuizL-game
#SQuizL
#SQL
loading . . .
https://bit.ly/SQuizL-game
about 2 months ago
0
1
0
Aj, too fast :) I should be more careful. SQuizL 03-OCT-25 2/6 guesses 65 seconds ๐ฉ๐ฉ๐ฉ๐ฉ๐ฉโฌ๐ฆ ๐ฉ๐ฉ๐ฉ๐ฉ๐ฉ๐ฉ๐ฆ
bit.ly/SQuizL-game
#SQuizL
#SQL
loading . . .
https://bit.ly/SQuizL-game
about 2 months ago
0
1
0
๐ SQuizL 02-OCT-25 1/6 guesses 161 seconds ๐ฉ๐ฆ๐ฉ๐ฉ๐ฉ๐ฉ๐ฉ
bit.ly/SQuizL-game
#SQuizL
#SQL
loading . . .
https://bit.ly/SQuizL-game
about 2 months ago
0
1
0
Another day with squizl :) SQuizL 01-OCT-25 1/6 guesses 51 seconds ๐ฉ๐ฉ๐ฉ๐ฉ๐ฆ๐ฉ๐ฉ
bit.ly/SQuizL-game
#SQuizL
#SQL
loading . . .
https://bit.ly/SQuizL-game
about 2 months ago
0
1
0
โฅ๏ธ The most beautifully located Oracle Conference this year will be celebrating its 30th anniversary! ๐ Iโm honored to have the opportunity to take part in this event and contribute with 2๏ธโฃ of my presentations! See you in beautiful Croatia! ๐
2025.hroug.hr/eng
#HROUG2025
@oracleace.bsky.social
about 2 months ago
0
7
1
Not my day :) SQuizL 30-SEP-25 5/6 guesses 718 seconds ๐ฉ๐ฉโฌโฌ๐จ๐ฉ๐ฉ ๐ฉ๐ฉ๐ฉ๐ฉโฌ๐ฉ๐ฉ ๐ฉ๐ฉ๐ฉ๐ฉโฌ๐ฉ๐ฉ ๐ฉ๐ฉ๐ฉ๐ฉโฌ๐ฉ๐ฉ ๐ฉ๐ฉ๐ฉ๐ฉ๐ฉ๐ฉ๐ฉ
bit.ly/SQuizL-game
#SQuizL
#SQL
loading . . .
https://bit.ly/SQuizL-game
about 2 months ago
0
1
0
๐ SQuizL 29-SEP-25 2/6 guesses 212 seconds ๐ฉโฌ๐ฉ๐ฆโฌโฌโฌ ๐ฉ๐ฉ๐ฉ๐ฆ๐ฉ๐ฉ๐ฉ
bit.ly/SQuizL-game
#SQuizL
#SQL
loading . . .
https://bit.ly/SQuizL-game
about 2 months ago
0
2
0
SQuizL 27-SEP-25 1/6 guesses 118 seconds ๐ฉ๐ฉ๐ฆ๐ฉ๐ฉ๐ฉ๐ฉ
bit.ly/SQuizL-game
#SQuizL
#SQL
loading . . .
https://bit.ly/SQuizL-game
about 2 months ago
0
1
0
Not bad. SQuizL 26-SEP-25 2/6 guesses 154 seconds ๐ฉ๐ฉ๐ฉ๐จ๐จ๐ฉ๐ฉ ๐ฉ๐ฉ๐ฉ๐ฉ๐ฉ๐ฉ๐ฉ
bit.ly/SQuizL-game
#SQuizL
#SQL
loading . . .
https://bit.ly/SQuizL-game
about 2 months ago
0
2
0
reposted by
Monika Lewandowska
Jonathan Lewis
about 2 months ago
Blog post for September 2025 SQL Developer isn't entirely CBO-friendly.
jonathanlewis.wordpress.com/2025/09/24/s...
4
21
8
After the summer break, I'm back at Squizl, better than ever! SQuizL 24-SEP-25 1/6 guesses 124 seconds ๐ฉ๐ฉ๐ฉ๐ฉ๐ฉ๐ฆ๐ฉ
bit.ly/SQuizL-game
#SQuizL
#SQL
loading . . .
https://bit.ly/SQuizL-game
about 2 months ago
0
1
0
reposted by
Monika Lewandowska
SQLDaily
2 months ago
The NVL function in Oracle
#SQL
returns The 1st argument if it's non-null Otherwise the 2nd argument Use it like so WHERE col = NVL ( :var, col ) And the plan can use an index if :var is non-null & a full table scan if it is
@monikalewandowska.bsky.social
demos
loading . . .
https://buff.ly/ef2CD1M
0
3
1
reposted by
Monika Lewandowska
Connor McDonald on Database and SQL
2 months ago
New post! MERGE is 23ai is even cooler than first appears...
connor-mcdonald.com/2025/09/18/m...
loading . . .
MERGE in 23ai โ so much more than RETURNING
Oracle ACE Andrej Pashchenko recently did a blog post covering a nice addition in 23ai, the ability for MERGE to use the RETURNING clause. Check his post for several examples, but as quick TL;DR, hโฆ
https://connor-mcdonald.com/2025/09/18/merge-in-23ai-so-much-more-than-returning/
0
8
4
[PL] LATERAL - pobawmy siฤ w chowanego i znajdลบmy razem znikajฤ cฤ kolumnฤ!
tinyurl.com/y5thn23b
[EN] LATERAL โ letโs play hide-and-seek and find the disappearing column together!
tinyurl.com/y8vbs2
loading . . .
LATERAL: zabawa w chowanego
Projektowanie i programowanie baz danych Oracle. Optymalizacja, Jakoลฤ.
https://tinyurl.com/y5thn23b
2 months ago
0
0
0
reposted by
Monika Lewandowska
Jonathan Lewis
2 months ago
And here's another blog note about how clever the optimizer can be. After using OR-expansion on nvl() to produce a union all of joins, the optimizer can decide to apply Join factorization to transform that to take common join tables outside the union all:
jonathanlewis.wordpress.com/2018/02/14/j...
0
2
1
reposted by
Monika Lewandowska
Jonathan Lewis
2 months ago
Went to
@monikalewandowska.bsky.social
presentation about nvl() at the
#POUG2025
conference and had a conversation about an unexpected cardinality estimate - which didn't reproduce in my version of Oracle - but prompted me to revisit an ancient blog note:
jonathanlewis.wordpress.com/2007/01/09/c...
2
4
2
Ready to go!
#POUG2025
!
@ora600pl.bsky.social
@luizafrompoland.bsky.social
@oracleace.bsky.social
@pdevisser.bsky.social
3 months ago
2
14
0
reposted by
Monika Lewandowska
Oracle ACE Program
3 months ago
Join the Oracle ACEs at POUG 2025 this week in Poznaล. Knowledge, lectures, discussion and networking for two full days! Join them now โ ๏ธ ๐
poug.org/en/edycja/po...
#OracleACE
@edelweissk.bsky.social
@ora600pl.bsky.social
@julianfrey.ch
@danischnider.bsky.social
@chandlerdba.bsky.social
0
16
7
reposted by
Monika Lewandowska
Connor McDonald on Database and SQL
3 months ago
Testing is always a critical component in the application life cycle, but sometimes it is going to be even more so...
connor-mcdonald.com/2025/09/02/m...
loading . . .
Mixing and matching
Iโve written some complex software in my years as an Oracle professional, but Iโm happy to concede that nothing comes remotely close to the complexity that must be present to run the Orโฆ
https://connor-mcdonald.com/2025/09/02/mixing-and-matching/
0
1
1
A while ago, I came across an interesting NVL trick on Connor Mc'Donald's blog.
tinyurl.com/yc6xkdcz
I found this example intriguing enough to explore it myself. Let's check, what is smarter/faster: NVL, COALESCE or old good query with OR.
tinyurl.com/mr7jay2j
@connormcd.bsky.social
loading . . .
The Magical NVL Function
A while ago, I came across an interesting NVL trick on Connor Mc'Donald's blog . In his example, he compares a query that uses an optiona...
https://tinyurl.com/mr7jay2j
3 months ago
0
2
3
Three performance presentations at the same time. You have no mercy!
@ora600pl.bsky.social
@luizafrompoland.bsky.social
@tmmdv.bsky.social
#POUG2025
3 months ago
2
0
0
reposted by
Monika Lewandowska
Polish Oracle User Group
3 months ago
Pretty proud and excited to announce that
#POUG2025
is sold out!๐ Thank you for your support & trust. It's gonna be super fun, just look at the agenda:
poug.org/edycja/poug-...
See you next week! POUG Team
0
11
4
Performance Grand Prix โ Who Will Win the Race? See you next week :) Agenda:
makeit.si/schedule/
#makeit
@oracleace.bsky.social
6 months ago
1
13
3
Coffee and post- conference blues...
#apexcpnnect25
6 months ago
0
6
0
reposted by
Monika Lewandowska
DOAG e.V.
7 months ago
๐ฃ
#apexconn25
โ T minus 13... โณ Am 13. Mai รถffnet die 11. APEX connect ihre Tรผren im Europa-Park in Rust. Der 2. Konferenztag endet mit einer groรen Dinner- & DJ-Party ๐ฝ๏ธ ๐ ๐ชฉ ๐ ๐ต ๐ป
scomp.ly/Q1zLZAG
Infos ๐
apex.doag.org
Tickets ๐
scomp.ly/Anlevna
Hotels ๐
scomp.ly/OWwJkd5
#orclapex
#lowcode
#plsql
0
11
8
๐ณ๏ธ SQuizL 25-APR-25 1/6 guesses 263 seconds ๐ฉ๐ฉ๐ฉ๐ฉ๐ฉ๐ฉ๐ฉ
bit.ly/SQuizL-game
#SQuizL
#SQL
loading . . .
https://bit.ly/SQuizL-game
7 months ago
0
0
0
SQuizL 15-APR-25 2/6 guesses 281 seconds ๐ฉ๐ฉ๐ฉ๐ฉโฌ๐ฆ๐ฉ ๐ฉ๐ฉ๐ฉ๐ฉ๐ฉ๐ฆ๐ฉ
bit.ly/SQuizL-game
#SQuizL
#SQL
loading . . .
https://bit.ly/SQuizL-game
7 months ago
0
0
0
๐ฐ๏ธ SQuizL 25-MAR-25 1/6 guesses 44 seconds ๐ฉ๐ฉ๐ฉ๐ฉ๐ฉ๐ฉ๐ฆ
bit.ly/SQuizL-game
#SQuizL
#SQL
loading . . .
https://bit.ly/SQuizL-game
8 months ago
0
0
0
Having issues with mouse cursor lag in SQL Developer for VS Code? Here's how to fix it!
tinyurl.com/3jnup6mt
loading . . .
How to deal with the mouse (cursor lagging in VS Code)?
Since the SQL Developer extension for VS Code was released, Iโve been using this tool every day. Functionally, the tool is meant to hav...
https://tinyurl.com/3jnup6mt
8 months ago
0
1
0
At the beginning, I started by looking for the "DROP" command. SQuizL 14-FEB-25 2/6 guesses 109 seconds ๐ฉ๐ฉ๐ฉ๐ฆโฌ๐จ๐จ ๐ฉ๐ฉ๐ฉ๐ฆ๐ฉ๐ฉ๐ฉ
bit.ly/SQuizL-game
#SQuizL
#SQL
loading . . .
https://bit.ly/SQuizL-game
9 months ago
0
0
0
๐ป SQuizL 13-FEB-25 1/6 guesses 166 seconds ๐ฉ๐ฉ๐ฉ๐ฉ๐ฉ๐ฉ๐ฉ
bit.ly/SQuizL-game
#SQuizL
#SQL
loading . . .
https://bit.ly/SQuizL-game
9 months ago
0
1
0
๐บ SQuizL 11-FEB-25 1/6 guesses 96 seconds ๐ฉ๐ฉ๐ฉ๐ฉ๐ฉ๐ฉ๐ฉ
bit.ly/SQuizL-game
#SQuizL
#SQL
loading . . .
https://bit.ly/SQuizL-game
9 months ago
0
0
0
โ๏ธ SQuizL 10-FEB-25 1/6 guesses 201 seconds ๐ฉ๐ฉ๐ฉ๐ฉ๐ฉ๐ฆ๐ฉ
bit.ly/SQuizL-game
#SQuizL
#SQL
loading . . .
https://bit.ly/SQuizL-game
10 months ago
0
0
0
๐ฅช SQuizL 09-FEB-25 1/6 guesses 69 seconds ๐ฉ๐ฉ๐ฉ๐ฉ๐ฉ๐ฉ๐ฉ
bit.ly/SQuizL-game
#SQuizL
#SQL
loading . . .
https://bit.ly/SQuizL-game
10 months ago
0
0
0
๐ท SQuizL 17-JAN-25 1/6 guesses 220 seconds ๐ฉ๐ฉ๐ฉ๐ฉ๐ฉ๐ฆ๐ฉ
bit.ly/SQuizL-game
#SQuizL
#SQL
loading . . .
https://bit.ly/SQuizL-game
10 months ago
0
1
0
SQuizL 08-JAN-25 2/6 guesses 93 seconds โฌ๐ฉ๐จโฌ๐ฆ๐ฉ๐ฉ ๐ฉ๐ฉ๐ฉ๐ฉ๐ฆ๐ฉ๐ฉ
bit.ly/SQuizL-game
#SQuizL
#SQL
loading . . .
https://bit.ly/SQuizL-game
11 months ago
0
2
0
hm SQuizL 07-JAN-25 1/6 guesses 286 seconds ๐ฉ๐ฉ๐ฉ๐ฆ๐ฉ๐ฉ๐ฉ
bit.ly/SQuizL-game
#SQuizL
#SQL
loading . . .
https://bit.ly/SQuizL-game
11 months ago
0
1
0
SQuizL 05-JAN-25 1/6 guesses 74 seconds ๐ฉ๐ฉ๐ฉ๐ฉ๐ฆ๐ฉ๐ฉ
bit.ly/SQuizL-game
#SQuizL
#SQL
loading . . .
https://bit.ly/SQuizL-game
11 months ago
0
1
0
๐ช SQuizL 03-JAN-25 1/6 guesses 60 seconds ๐ฉ๐ฉ๐ฉ๐ฉ๐ฉ๐ฆ๐ฉ
bit.ly/SQuizL-game
#SQuizL
#SQL
loading . . .
https://bit.ly/SQuizL-game
11 months ago
0
1
0
[PL] Prรณbujesz zainstalowaฤ schemat HR na bazie 23ai i dostajesz bลฤ d ORA-65096? Zobacz, jak rozwiฤ zaฤ ten problem!
tinyurl.com/yt33m42d
[EN] Trying to install the HR schema on a 23ai database and getting the ORA-65096 error? Here's how to resolve this issue!
tinyurl.com/4jh78485
loading . . .
Jak zainstalowaฤ schemat HR na bazie Oracle 23ai? (ORA-65096)
Projektowanie i programowanie baz danych Oracle. Optymalizacja, Jakoลฤ.
https://tinyurl.com/yt33m42d
11 months ago
1
0
0
Load more
feeds!
log in