Monika Lewandowska
@monikalewandowska.bsky.social
๐ค 321
๐ฅ 209
๐ 93
๐ฎOracle Witch โ ๏ธ Oracle ACE Pro ๐ฉโ๐ซTrainer ๐how2ora-en.blogspot.com
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 15 hours 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
1 day ago
0
5
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
1 day 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
3 days 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
4 days 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
6 days ago
0
2
0
reposted by
Monika Lewandowska
Jonathan Lewis
8 days ago
Blog post for September 2025 SQL Developer isn't entirely CBO-friendly.
jonathanlewis.wordpress.com/2025/09/24/s...
4
20
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
8 days ago
0
1
0
reposted by
Monika Lewandowska
SQLDaily
9 days 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
14 days 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
15 days ago
0
0
0
reposted by
Monika Lewandowska
Jonathan Lewis
23 days 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
23 days 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
28 days ago
2
14
0
reposted by
Monika Lewandowska
Oracle ACE Program
29 days 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
29 days 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
30 days 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
about 1 month ago
2
0
0
reposted by
Monika Lewandowska
Polish Oracle User Group
about 1 month 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
4 months ago
1
13
3
Coffee and post- conference blues...
#apexcpnnect25
5 months ago
0
6
0
reposted by
Monika Lewandowska
DOAG e.V.
5 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
5 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
6 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
6 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
6 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
8 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
8 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
8 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
8 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
8 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
9 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
9 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
9 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
9 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
9 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
9 months ago
1
0
0
๐ค SQuizL 02-JAN-25 2/6 guesses 200 seconds ๐ฉ๐จโฌ๐ฉ๐ฉ๐ฆ๐ฉ ๐ฉ๐ฉ๐ฉ๐ฉ๐ฉ๐ฆ๐ฉ
bit.ly/SQuizL-game
#SQuizL
#SQL
loading . . .
https://bit.ly/SQuizL-game
9 months ago
0
2
0
๐ค SQuizL 20-DEC-24 1/6 guesses 140 seconds ๐ฉ๐ฉ๐ฉ๐ฉ๐ฉ๐ฉ๐ฉ
bit.ly/SQuizL-game
#SQuizL
#SQL
loading . . .
https://bit.ly/SQuizL-game
10 months ago
0
3
0
๐ SQuizL 19-DEC-24 2/6 guesses 277 seconds โฌโฌ๐จโฌ๐ฆ๐ฉ๐ฉ ๐ฉ๐ฉ๐ฉ๐ฉ๐ฆ๐ฉ๐ฉ
bit.ly/SQuizL-game
#SQuizL
#SQL
loading . . .
https://bit.ly/SQuizL-game
10 months ago
0
2
0
[PL] Wiesz, ลผe funkcja ROUD moลผe byฤ zastosowana rรณwnieลผ do typu danych DATE? Sprawdลบ przykลady!
tinyurl.com/5fkm3rme
[ENG] Did you know that the ROUND function can also be applied to the DATE data type? Check examples!
tinyurl.com/4asx8bsn
10 months ago
0
0
0
SQuizL 08-DEC-24 1/6 guesses 127 seconds ๐ฉ๐ฉ๐ฆ๐ฉ๐ฉ๐ฉ๐ฉ
bit.ly/SQuizL-game
#SQuizL
#SQL
loading . . .
https://bit.ly/SQuizL-game
10 months ago
0
6
0
โ SQuizL 05-DEC-24 1/6 guesses 59 seconds ๐ฉ๐ฆ๐ฉ๐ฉ๐ฉ๐ฉ๐ฆ
bit.ly/SQuizL-game
#SQuizL
#SQL
loading . . .
https://bit.ly/SQuizL-game
10 months ago
0
2
0
๐ฅ๏ธ SQuizL 03-DEC-24 1/6 guesses 140 seconds ๐ฉ๐ฉ๐ฉ๐ฉ๐ฉ๐ฉ๐ฉ
bit.ly/SQuizL-game
#SQuizL
#SQL
loading . . .
https://bit.ly/SQuizL-game
10 months ago
0
2
0
๐ฆน SQuizL 30-NOV-24 2/6 guesses 473 seconds ๐ฉ๐ฉ๐จโฌ๐จ๐ฆ๐ฉ ๐ฉ๐ฉ๐ฉ๐ฉ๐ฉ๐ฆ๐ฉ
bit.ly/SQuizL-game
#SQuizL
#SQL
loading . . .
https://bit.ly/SQuizL-game
10 months ago
0
2
0
Interestingly, after the fourth attempt, I gave up and started clicking random phrases. And bam, it worked! :} ๐
devgym.oracle.com/pls/apex/f?p...
:
loading . . .
https://devgym.oracle.com/pls/apex/f?p=10001:4244:::::
10 months ago
0
1
0
reposted by
Monika Lewandowska
Gunter Rotsaert
10 months ago
Simplicity is a great virtue but it requires hard work to achieve it and education to appreciate it. And to make matters worse: complexity sells better. - Edgar Dijkstra #quotes #quoteoftheday
0
14
4
oj ๐ SQuizL 28-NOV-24 2/6 guesses 367 seconds ๐จ๐จโฌ๐ฆโฌ๐จโฌ ๐ฉ๐ฉ๐ฉ๐ฆ๐ฉ๐ฉ๐ฉ
bit.ly/SQuizL-game
#SQuizL
#SQL
loading . . .
https://bit.ly/SQuizL-game
10 months ago
0
2
0
๐ซฅ SQuizL 27-NOV-24 5/6 guesses 4915 seconds ๐ฉ๐ฉโฌโฌโฌ๐จ๐ฆ ๐ฉ๐ฉ๐จ๐จโฌ๐ฉ๐ฆ ๐ฉ๐ฉ๐ฉโฌ๐ฉ๐ฉ๐ฆ ๐ฉ๐ฉ๐ฉโฌ๐ฉ๐ฉ๐ฆ ๐ฉ๐ฉ๐ฉ๐ฉ๐ฉ๐ฉ๐ฆ
bit.ly/SQuizL-game
#SQuizL
#SQL
loading . . .
https://bit.ly/SQuizL-game
10 months ago
0
2
0
โ๏ธ SQuizL 24-NOV-24 2/6 guesses 489 seconds ๐ฉ๐ฉโฌ๐ฆ๐ฉ๐ฉ๐ฉ ๐ฉ๐ฉ๐ฉ๐ฆ๐ฉ๐ฉ๐ฉ
bit.ly/SQuizL-game
#SQuizL
#SQL
loading . . .
https://bit.ly/SQuizL-game
10 months ago
0
1
0
Load more
feeds!
log in