How to Hierarchical Query, Parents, Children and Their Cycles

This is a three-part Series How to Hierarchical Query, Parents, Children and Their Cycles How To Create Report in Oracle APEX based on Hierarchical Query How to use Hierarchical Query in Tree Plugin Part-1 How to Hierarchical Query, Parents, Children and Their Cycles Almost every one on this planet like trees right. Some of us like them as essential part of the world ecological system while others have created a very peculiar taste...

Read More

How To Treat The NULL Vacuum

It make some sense as the vacuum is something devoid of matter, something we do not really know about its contents, As does the NULL in a database. Here are a few points that need consideration as NULL plays the role of a double-edged sword in a database, providing a very efficient way to store unknown values , however not treated wisely could have a nastier effect especially, during data manipulation: The Term null value is inaccurate...

Read More