Steven Feuerstein created this “I LOVE PL/SQL, AND…” web site at ILovePLSQLAnd.net with the intention to collect the list of gaps/issues PL/SQL (his passion) currently has. In his recent post, he met with the PL/SQL developers at Oracle headquarter, and received confirmation that they really listen to inputs from his web site. Sharing the same …
I just read a good whitepaper titled “For Developers: Making Friends with the Oracle Database” by Cary Millsap. Cary makes an excellent point that most developers think of database as a black box. However, by progressively understanding Oracle kernel little by little, they can improve performance of their queries dramatically. I appreciate the way Cary …
Good whitepaper “For Developers: Making Friends with the Oracle Database” Read More »
I’ve been looking for a way to help my kid learning computer programming. My daughter and I tried out the trial version of “Phrogram” which is listed in the top hits when googling for “kid programming”. It is nice, well-made and powerful by just looking at provided samples. Its look & feel and language look …
Currently I’m working on a project dealing with lot of statistic calculations particularly that of quartiles. First, I have no idea what it is. Thanks to Wiki for explanation. Now the tough part is to do the actual calculation. Fortunately, Oracle provides DBMS_STAT_FUNCS which is exactly what I’m looking for. List of available calculations – …
