All posts under SQL

A collection that makes PL/SQL Developer crash!

I’ve been struggling for a couple of months , with this very annoying problem. Whenever I issued a query like where table_varchar is a type I use defined like my PL/SQL Developer would always crash ! Today , with a tip from a friend I found the reason ! To[…]


Oracle SQL curiosity of the day

While testing around with user HR from Oracle 11g Database samples, I found curious that : only returns 16 rows when it should return 22 ! This happens because the SQL engine┬áliterally interprets NULL as a non-existing value. So any columns with a NULL state province will not display :[…]