കാലാന്തരം
I don’t know why!
Sometimes we don’t realise the beauty of something we created until someone recognises it.
Maybe we are too humble to acknowledge our work is as good as someone else’s, or maybe we don’t have enough confidence to take pride in something we created.
I don’t know why!
PS: These paintings were done by my wife, and yet she still believes she can’t draw.
Let me know your comments on the above. Thank you!
Poet
I am the wizard
who can make you dream,
fall in love,
dance in the rain,
find peace,
and enlighten you.
Yes, I am a poet.
അമരന്മാർ
നിങ്ങൾ മതങ്ങളിലേക്ക്
ചുരുങ്ങി മരിക്കുമ്പോൾ,
ഞങ്ങൾ മനുഷ്യരിലേക്ക്
പടർന്ന് അമരന്മാരാകും.
തുടരും
സമരസൂര്യൻ
അസ്തമച്ചോപ്പിൽ
അലിയുമ്പോൾ,
അയാൾ ഉയർത്തിയ
ആശയത്തിന് കീഴെ
നാമിനിയും പോരാട്ടം
തുടരും.
NOT IN vs NOT EXISTS in PL/SQL
SELECT *
FROM TABLE1
WHERE ID NOT IN (
SELECT ID
FROM TABLE2
)
When I ran the above query I know the condition will give me the results, because the data exists in the TABLE1 which is not in TABLE2. But I didn’t go any results. I got surprised. After I a while I found out the issue.
So the reason is that ID column in the TABLE2 have null values. If any value of ID in the subquery is NULL, then the entire NOT IN clause fails to match anything. This is standard SQL behavior because NULL makes the whole comparison unknown.
Solution:
- You can use
NOT NULLcondition in the sub-query as below:
SELECT *
FROM TABLE1
WHERE ID NOT IN (
SELECT ID
FROM TABLE2
WHERE ID IS NOT NULL
)
- Use
NOT EXISTS:
SELECT *
FROM TABLE1 T1
WHERE NOT EXISTS (
SELECT 1
FROM TABLE2 T2
WHERE T1.ID = T2.ID
)
The NOT EXISTS will automatically handle null values and safer to use.
References
Difference between React and ReactDOM
Good bye Georgia!
Until next time, good bye Georgia! Thank you for filling my hands with memories and my heart with love and kindness. ♥️🇬🇪
Whispering winds
When the mountain smiles and the wind whispers to you, you’ll know you’re a mountain person.
