This is my v2 of a presentation on ideas for going beyond the Application Express default graphs and info on 3 popular Javascript graphing libraries that can be incorporated into Apex Applications. 2013-06-DavidMann-ExploreNewDataDimensionsWithApexAndFOSSGraphingLibraries.pdf The visualization space is growing daily so I expect things to evolve,…
During my preparation for a visualization presentation at East Coast Oracle Users Group I realized I had an opportunity for a teaching moment on Levels of Abstraction. A few months back I published my PL/SQL code for an Archived Log Switch Heat Map. Below is…
I added a page to my SQL Developer Tips and Tricks page about integrating the Google Graph API with SQL Developer HTML reports. I sometimes run out of steam with the built in chart and gauge capabilities of SQL Developer. With a little work you…
... or just use SQLPLUS to spool to HTML and open with a browser if you are old school :) I am on week 4 of my newly reimaged work laptop sans Toad. I am trying to make a go of things with SQL Developer…
I came across this PL/SQL page today which has pointers to a lot of interesting stuff you can do with PL/SQL. From the page: It includes a lot of things I never really figured I would need to do in PL/SQL, but it is nice…
I came across a situation where the profiler.sql supplied with Metalink Doc: 243755.1 was giving some incomplete results. Because some of my PL/SQL code was executing very quickly it was rounding down to 0.00 and not even showing up on the 'Top 10' section. Throughout…
Iggy Fernandez covers the topic of who is better suited to tune SQL - Developers or DBAs. Also listed are 5 Dangerous Beliefs which may influence the answer to that question. https://iggyfernandez.wordpress.com/2009/07/12/who-should-tune-sql-the-dba-or-the-developer/ -Dave Dangerous Belief #1: DBAs bear chief responsibility for the performance of SQL…