Monday, January 5, 2009

That font is too small!

I think what God took from the hair on my head he gave to the vision of my eyes. As a consequence I like smaller fonts that display more data on the screen... But end users can hate this! The following solution was made to help the poster of this form thread and the many end users out there that still have hair ;) Here's a little demo...

  1. Install jQuery.
  2. Create an application item called FONT_SIZE_ADJ.
  3. Create an On Demand process called RETURN_NOTHING and enter the following for the body (yes, it's really one line that says 'null;'):
    NULL;
  4. Modify the page template to include the following (I put mine right before the 'td' that held the navigation bar):
    <td style="white-space:nowrap">
       (-) 
       Save
        / 
       Reset
        (+)
    </td>
  5. Paste the following in the HTML Header of the page:
    
    
    

The original thread had to do with Interactive Reports so that's what this code works with but it should be easy enough to modify the code to suit your needs. You could even save the user's preference and load it when they login to the application. Also, keep page 0 in mind if you want to use this throughout the entire application.

  • Update 5-JAN-2009: Updated code to handle the interactive report refreshing better. Still working on something to fix IE.

Sunday, January 4, 2009

New Years Resolutions

Many people do not like making New Years resolutions. I, however, can rarely resist the opportunity to try to better myself - even if the opportunity is really only motivational. This year I have 3 "professional" resolutions and at the behest of Chet Justice, I've decided to share them...

  1. Oracle Database 11g Administrator Certified Associate - I've been PL/SQL certified for a while and always wanted to learn more on the DBA side of Oracle. Certification is a great way to get exposed to a lot of options and features but it takes hard work and experience to get good with them. I'm really hoping that Oracle will offer an ApEx certification eventually. Until then DBA OCA, here I come.
  2. A  New Open Source Project (plRecur) - My first open source project, tapiGen, was a bit of a failure. Not that it was particularly bad code or didn't do what it was supposed to... I believe it failed because it required such a big change in the way one codes it was perhaps a little impractical. I've learned a bit from that and have something else in mind this time around. Actually, I've already begun coding ;) plRecur will be a PL/SQL package based API for working with things that recur. Typically this is an event of some kind.

    Of course working with recurrence is nothing new. My early attempts with this functionality are embarrassing to look back on. They where highly proprietary and not very flexible. The idea with plRecur is two fold: First to create a PL/SQL package based backend that makes working with recurrence easy and second to create a basic ApEx page region based frontend that can be used to interact with the backend.

    The calendaring syntax will be based on DBMS_SCHEDULER's calendaring syntax so experience with that will help. More details on this project will follow soon but here's a brief teaser... The calendar feeds off a call to pl_recur.dates_pipe which is a pipelined function.
  3. Become More Fluent In Spanish - This obviously has nothing to do with Oracle or ApEx, but it's something I need to keep working on!