Monika Lewandowska
@monikalewandowska.bsky.social
🔮Oracle Witch ♠️ Oracle ACE Pro 👩🏫Trainer
🔗how2ora-en.blogspot.com
🔗how2ora-en.blogspot.com
Speed SQL results for quiz on 10-OCT-2025
Attempt #1: 9 correct in 53 seconds
✖ ✔ ✔ ✔ ✔ ✔ ✔ ✔ ✔ ✔
#SpeedSQL devgym.oracle.com/pls/apex/f?p...
Attempt #1: 9 correct in 53 seconds
✖ ✔ ✔ ✔ ✔ ✔ ✔ ✔ ✔ ✔
#SpeedSQL devgym.oracle.com/pls/apex/f?p...
devgym.oracle.com
October 10, 2025 at 6:56 AM
Speed SQL results for quiz on 10-OCT-2025
Attempt #1: 9 correct in 53 seconds
✖ ✔ ✔ ✔ ✔ ✔ ✔ ✔ ✔ ✔
#SpeedSQL devgym.oracle.com/pls/apex/f?p...
Attempt #1: 9 correct in 53 seconds
✖ ✔ ✔ ✔ ✔ ✔ ✔ ✔ ✔ ✔
#SpeedSQL devgym.oracle.com/pls/apex/f?p...
[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
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
Krótki przewodnik instalacji dockera na Windows dla Erika.
Projektowanie i programowanie baz danych Oracle. Optymalizacja, Jakość.
tinyurl.com
October 8, 2025 at 7:26 PM
[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
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
Speed SQL results for quiz on 08-OCT-2025
Attempt #1: 10 correct in 41 seconds
✔ ✔ ✔ ✔ ✔ ✔ ✔ ✔ ✔ ✔
#SpeedSQL devgym.oracle.com/pls/apex/f?p...
Attempt #1: 10 correct in 41 seconds
✔ ✔ ✔ ✔ ✔ ✔ ✔ ✔ ✔ ✔
#SpeedSQL devgym.oracle.com/pls/apex/f?p...
devgym.oracle.com
October 8, 2025 at 7:22 AM
Speed SQL results for quiz on 08-OCT-2025
Attempt #1: 10 correct in 41 seconds
✔ ✔ ✔ ✔ ✔ ✔ ✔ ✔ ✔ ✔
#SpeedSQL devgym.oracle.com/pls/apex/f?p...
Attempt #1: 10 correct in 41 seconds
✔ ✔ ✔ ✔ ✔ ✔ ✔ ✔ ✔ ✔
#SpeedSQL devgym.oracle.com/pls/apex/f?p...
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...
Speed SQL results for quiz on 07-OCT-2025
Attempt #1: 10 correct in 43 seconds
✔ ✔ ✔ ✔ ✔ ✔ ✔ ✔ ✔ ✔
#SpeedSQL devgym.oracle.com/pls/apex/f?p...
devgym.oracle.com
October 7, 2025 at 6:28 AM
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...
Speed SQL results for quiz on 07-OCT-2025
Attempt #1: 10 correct in 43 seconds
✔ ✔ ✔ ✔ ✔ ✔ ✔ ✔ ✔ ✔
#SpeedSQL devgym.oracle.com/pls/apex/f?p...
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...
Speed SQL results for quiz on 06-OCT-2025
Attempt #1: 9 correct in 42 seconds
✔ ✔ ✔ ✔ ✔ ✔ ✔ ✔ ✖ ✔
#SpeedSQL devgym.oracle.com/pls/apex/f?p...
devgym.oracle.com
October 6, 2025 at 7:28 AM
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...
Speed SQL results for quiz on 06-OCT-2025
Attempt #1: 9 correct in 42 seconds
✔ ✔ ✔ ✔ ✔ ✔ ✔ ✔ ✖ ✔
#SpeedSQL devgym.oracle.com/pls/apex/f?p...
A great way to kick off the weekend <3
SQuizL 04-OCT-25
1/6 guesses
85 seconds
🟩🟩🟩🟩🟩🟩🟩
bit.ly/SQuizL-game
#SQuizL #SQL
SQuizL 04-OCT-25
1/6 guesses
85 seconds
🟩🟩🟩🟩🟩🟩🟩
bit.ly/SQuizL-game
#SQuizL #SQL
bit.ly
October 4, 2025 at 1:08 PM
A great way to kick off the weekend <3
SQuizL 04-OCT-25
1/6 guesses
85 seconds
🟩🟩🟩🟩🟩🟩🟩
bit.ly/SQuizL-game
#SQuizL #SQL
SQuizL 04-OCT-25
1/6 guesses
85 seconds
🟩🟩🟩🟩🟩🟩🟩
bit.ly/SQuizL-game
#SQuizL #SQL
Aj, too fast :) I should be more careful.
SQuizL 03-OCT-25
2/6 guesses
65 seconds
🟩🟩🟩🟩🟩⬜🟦
🟩🟩🟩🟩🟩🟩🟦
bit.ly/SQuizL-game
#SQuizL #SQL
SQuizL 03-OCT-25
2/6 guesses
65 seconds
🟩🟩🟩🟩🟩⬜🟦
🟩🟩🟩🟩🟩🟩🟦
bit.ly/SQuizL-game
#SQuizL #SQL
bit.ly
October 3, 2025 at 6:38 AM
Aj, too fast :) I should be more careful.
SQuizL 03-OCT-25
2/6 guesses
65 seconds
🟩🟩🟩🟩🟩⬜🟦
🟩🟩🟩🟩🟩🟩🟦
bit.ly/SQuizL-game
#SQuizL #SQL
SQuizL 03-OCT-25
2/6 guesses
65 seconds
🟩🟩🟩🟩🟩⬜🟦
🟩🟩🟩🟩🟩🟩🟦
bit.ly/SQuizL-game
#SQuizL #SQL
Another day with squizl :)
SQuizL 01-OCT-25
1/6 guesses
51 seconds
🟩🟩🟩🟩🟦🟩🟩
bit.ly/SQuizL-game
#SQuizL #SQL
SQuizL 01-OCT-25
1/6 guesses
51 seconds
🟩🟩🟩🟩🟦🟩🟩
bit.ly/SQuizL-game
#SQuizL #SQL
bit.ly
October 1, 2025 at 9:40 AM
Another day with squizl :)
SQuizL 01-OCT-25
1/6 guesses
51 seconds
🟩🟩🟩🟩🟦🟩🟩
bit.ly/SQuizL-game
#SQuizL #SQL
SQuizL 01-OCT-25
1/6 guesses
51 seconds
🟩🟩🟩🟩🟦🟩🟩
bit.ly/SQuizL-game
#SQuizL #SQL
♥️ 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
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
September 30, 2025 at 7:37 AM
♥️ 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
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
Not my day :)
SQuizL 30-SEP-25
5/6 guesses
718 seconds
🟩🟩⬜⬜🟨🟩🟩
🟩🟩🟩🟩⬜🟩🟩
🟩🟩🟩🟩⬜🟩🟩
🟩🟩🟩🟩⬜🟩🟩
🟩🟩🟩🟩🟩🟩🟩
bit.ly/SQuizL-game
#SQuizL #SQL
SQuizL 30-SEP-25
5/6 guesses
718 seconds
🟩🟩⬜⬜🟨🟩🟩
🟩🟩🟩🟩⬜🟩🟩
🟩🟩🟩🟩⬜🟩🟩
🟩🟩🟩🟩⬜🟩🟩
🟩🟩🟩🟩🟩🟩🟩
bit.ly/SQuizL-game
#SQuizL #SQL
bit.ly
September 30, 2025 at 7:11 AM
Not my day :)
SQuizL 30-SEP-25
5/6 guesses
718 seconds
🟩🟩⬜⬜🟨🟩🟩
🟩🟩🟩🟩⬜🟩🟩
🟩🟩🟩🟩⬜🟩🟩
🟩🟩🟩🟩⬜🟩🟩
🟩🟩🟩🟩🟩🟩🟩
bit.ly/SQuizL-game
#SQuizL #SQL
SQuizL 30-SEP-25
5/6 guesses
718 seconds
🟩🟩⬜⬜🟨🟩🟩
🟩🟩🟩🟩⬜🟩🟩
🟩🟩🟩🟩⬜🟩🟩
🟩🟩🟩🟩⬜🟩🟩
🟩🟩🟩🟩🟩🟩🟩
bit.ly/SQuizL-game
#SQuizL #SQL
Reposted by Monika Lewandowska
Blog post for September 2025
SQL Developer isn't entirely CBO-friendly.
jonathanlewis.wordpress.com/2025/09/24/s...
SQL Developer isn't entirely CBO-friendly.
jonathanlewis.wordpress.com/2025/09/24/s...
September 24, 2025 at 12:29 PM
Blog post for September 2025
SQL Developer isn't entirely CBO-friendly.
jonathanlewis.wordpress.com/2025/09/24/s...
SQL Developer isn't entirely CBO-friendly.
jonathanlewis.wordpress.com/2025/09/24/s...
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
SQuizL 24-SEP-25
1/6 guesses
124 seconds
🟩🟩🟩🟩🟩🟦🟩
bit.ly/SQuizL-game
#SQuizL #SQL
bit.ly
September 24, 2025 at 12:26 PM
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
SQuizL 24-SEP-25
1/6 guesses
124 seconds
🟩🟩🟩🟩🟩🟦🟩
bit.ly/SQuizL-game
#SQuizL #SQL
Reposted by Monika Lewandowska
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
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
buff.ly
September 23, 2025 at 11:02 AM
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
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
Reposted by Monika Lewandowska
[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
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
LATERAL: zabawa w chowanego
Projektowanie i programowanie baz danych Oracle. Optymalizacja, Jakość.
tinyurl.com
September 17, 2025 at 7:25 AM
[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
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
Reposted by Monika Lewandowska
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...
jonathanlewis.wordpress.com/2018/02/14/j...
September 9, 2025 at 9:24 AM
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...
jonathanlewis.wordpress.com/2018/02/14/j...