Scott Spendolini's Blog

Just read on the Revion blog that a new subsidiary called HTMLDBHost is offering APEX hosting at $24.95 for the first six months; the price goes up to the regular rate of $49.95 thereafter. It seems that you get the same levels of service, band width, disk space as the standard plan offered at Revion.com at a discounted rate.

In case you missed it, the APEX 3.1.1 patchset has been released as both a patch via Metalink (patch #7032837) and a complete download via OTN. For a complete list of what's fixed, have a look at the patch's installation notes .

I just got an e-mail from Bank of America: During our regularly scheduled account maintenance and verification procedures, we have detected a slight error in your billing information. This might be due to either of the following reasons: 1. A recent change in your personal information (i.e.change of address). 2. Submiting invalid information during the initial sign up process. 3. The services look that was changed recently: [Banking Log-In] Security Advisory, Bank Of America . *Important* failure to update your account at least 24hrs of notice might lead to account being locked and access will be restricted. I'll ignore the fact that I do not have a Bank of America account for the sake of this post, as that's just too easy. So let's review the signs thus far: Sign #1 : "Either" of the following reasons, followed by three, not two, reasons. Sign #2 : Poor grammar: The services look that was changed recently Sign #3 : Poor punctuation: failure to upd

Doug Gault from Hotsos will be presenting a FREE webinar on May 28th: Performance Tuning APEX Applications . From the Hotsos site: Application Express (ApEx) is a highly flexible and highly scalable Rapid Application Development environment for web applications. But what do you do when your application's success starts to become its downfall? This free, one-hour presentation will cover strategies and tactical advice for monitoring and addressing performance issues, and presents some of the best practices for making ApEx Performance Problems easy to diagnose. This webinar is presented by Doug Gault, head of Hotsos Product Development. No one that I know of does Oracle Performance Tuning like the folks at Hotsos do, so I'm sure that this presentation will be packed with tips and best practices.

I can across this post today (Disclaimer: link is very much NSFW only if you try to repeat the examples used for Urban Dictionary; also, other entries in this blog may be NSFW): http://www.cogentmetal.org/aux/archives/2008/if-you-arent-using-firefox-smart-keywords-you-arent-smart-or-a-keyword/ To summarize, Firefox allows you to not only bookmark a page, but turn that page into a function of sort, and allow you cal call that page with some sort of parameter. Thus, if you add a Smart Keyword for Google and call it "g", you can simply type "g oracle apex" into the location bar, and the resulting page would be the same as if you went to google.com, entered "oracle apex", and then clicked enter. So naturally, my first instinct to was to test this with an APEX application, and I was quite pleased to see it work flawlessly! I added two Smart Keywords - "a" and "c", which search the Accounts and Contacts pages of my APEX-based CRM application

Having just answered a question in the OTN forums on this, I figured I'd share the link that I often use to decode which feature maps to which version of the Oracle Database: http://www.oracle.com/database/product_editions.html Since Oracle will change what feature is included with which edition from time to time, it's handy to have this link bookmared somewhere. Also, what's most unique about this link is that it can only be (easily) found from oracle.com, not OTN.

I have been using SQL Developer since its early days, namely because it runs natively on the Mac.  Despite this fact, it has proven to be a formidable IDE to work with, allowing me to do 95% of what I need to quickly and easily, all without having to spark up a Windows VM. In this month's Oracle Magazine, David Peake , the APEX Product Manager, writes about how to use SQL Developer to assist in debugging APEX applications.  By instrumenting your processes in APEX with just a couple lines of code, you can trap and then debug your PL/SQL from APEX in SQL Developer's debugger. While you'll need DBA privileges to get this to work, it's something that's not intended for production environments, so I don't envision that to be much of an issue in most cases.