Hi all! One of the most used database concept is hierarchies. Why? Basically, any relation that can be categorized as a “Father” – “Son” relationship can take advantage of this concept. Lets us imagine you want to represent the relationship between an employer and an employee. You could probably create two[…]
All posts under Oracle
How to find direct and indirect dependencies between Oracle objects?
Hi all ! One of the biggest hassles I had a couple of months ago was how to find dependencies between Oracle objects. As always, after some internet browsing I found out that there was something to help us! Before I go into further details let me just briefly explain[…]
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[…]
Where does Oracle process SQL statements ?
Programming,programming,programming…a way a of life.(kind of!) But how many times do we actually stop to think about what we are doing ? I decided to blog on this, because it is important to always keep in mind some basic concepts Whenever we need to execute a SQL statement, Oracle allocates[…]
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 :[…]