Scott Spendolini's Blog

There is now an ApEx project on SourceForge.net. There is also a Project Home Page, hosted on apex.oracle.com here . According to the site, the goal of the project is to "facilitate development of Oracle Application Express (APEX) applications until they gain enough momentum of their own to become their own separate projects." Some of the initial projects include a Forum, Wiki, Blog, and AskSomeone, which if you can't tell, is based on AskTom.oracle.com. This move represents another step in the maturity of ApEx as a development environment. As this project grows, more "cookie cutter" applications will be available for common tasks, making it even easier and quicker to deploy ApEx applications.

It's been a while since I've updated my blog. I've been quite busy lately, and just have not had the time that I used to. We're expecting our 1st child in just a few short weeks now, so most of my free time has been spent learning Lamaze breathing, making the weekly run to Babies R Us, and relocating my office from the larger room upstairs to the smaller one downstairs - which I do happen to like MUCH more than I had anticipated. I have everything I need within a short walk - a bathroom, beer fridge, and 52" HD TV. I only need to go upstairs to eat and sleep now, but alas, this will all change soon... Recently, I was asked if you could change the way Export to CSV in ApEx works. The short answer is, of course, no. But it's not too difficult to "roll your own" CSV export procedure. Why would you want to do this? Well, the customer's requirement was to manipulate some data when the Export link was clicked, and then export it to CSV in a forma...

What? There's no way to put a Branch on Page 0 of an ApEx application! Or is there... Technically, no - page 0 does not support branches. But how many times do you wish it did? This scenario recently came up: I wanted to put a "Search" box on every page in my application, so no matter where a user is, they can search the site. Currently, it has 10 or so pages, but this will grow to closer to 50 by production. So, thought #1 was to put an text item on Page 0, call it search, and then ensure that each and every page had some sort of Branch to run the search. Not so fun, as this was a tedious task, even for just 10 pages. And each time a new page was added to the application - by myself or anyone else - the search branch would have to be added to the page. Clearly not a scalable solution. With a little bit of help from Raj from the ApEx team, I came up with this solution: Create Page 0, if you haven't already On page 0, create an item of type "Text Field (...

As noted on Boing Boing , Yahoo! just released its UI Library , an open-source set of AJAX user interface components that developers can use in their sites for free! From Trees to Sliders, some of these components look quite slick! The real challenge here is not getting them to work with Oracle ApEx, but rather finding practical applications for them. So often I see sites where AJAX is used for the sake of using AJAX, and the result is just a mess. What intriques me are the reasons behind this. As I've been told many times, there is no such thing as a free anyyhing - it's just a question of when and how you pay. Perhaps Yahoo is trying to steer developers to its services (Maps, Calendar, Mail, etc.) in a pre-emptive strike against Google? Should be interesting to see how it all plays out.

Recently, I’ve been experimenting with using DIVs instead of TABLEs for creating Region Templates in Oracle Application Express. DIVs seem to have a lot less “moving parts” – or places where the code can become corrupted. Troubleshooting a missing <TD> tag is never a fun exercise, and by using DIVs, you can largely avoid that. However, DIVs tend to have issues with cross-browser development. What looks great on Firefox doesn’t even render on MSIE. That alone can be a challenge to troubleshoot, Having said all of this, I was able to take this Region Template: <table width="100%" cellpadding="0" cellspacing="0" id="#REGION_ID#"> <tr> <td> <table border="0" cellpadding="1" cellspacing="0" width="100%"> <tr> <td bgcolor="#666666"> <table border="0" cellpadding="0" cellspacing="0" width="100%" bgcolor=...

That's right - Oracle HTML DB has officially been renamed to Oracle Application Express . You still don't need Oracle Application Server, and it has nothing to do with Oracle Express or Express Objects, but it does coincide with the name of Oracle Express Edition Database. This renaming campaign came up once every few months or so when I was at Oracle, as we could never quite come to a consensus on what it should be renamed to. Looks like somoene finally made the call! My only fear with this new name is that people will associate Application with Oracle Application Server, as in it's a required component (as I said before, it still isn't) and Express with "small and insignificant", which is clearly not the limitations of HTML DB - umm, Application Express. It's going to take some getting used to...

Well, not really, as that would be bad. However, I’ve often wondered how to include a field for the username and password on every public page, making the sign on process one less click. Well, there’s nothing like learning how to do something like having a customer requirement! A current client wants a largely public site – that is, you do not need to authenticate to see most of it. Simple enough – just set the Page Attributes Security to Page is Public . However, the client also wanted the username and password field to appear on each and every public page. From a developer point of view, I didn’t want to have to put any items on any page aside from Page Zero. Thus, every time that I add a page to the application, the login region would simply show up. This required a bit more thought. Here’s what I came up with: I created a region on Page Zero which holds my username and password fields, as well as a Login button. The button is not an item button, but rather a true button whi...

As Laurent Schneider reported , a new version of Project Raptor has been released on OTN .

Starting your own business makes you learn how to play many roles: project manager, consultant, marketing department, technical support, “executive”, and – worst of all – accountant. I say that because I really, really, really hate accounting. Maybe I just had a bad experience in college, and could never really appreciate it. Perhaps I’m even a bit ignorant about it. In any case, there’s software out there to help someone like me. Right? I bought QuickBooks based on several recommendations from co-workers. The folks at Intuit have done a tremendous job! That is, if their job was to create the most un-user friendly, non-intuitive, archaic piece of software. I don’t even know where to start. They tried way too hard to over-engineer the UI. Everything is “cute”, with arrows, icons, and more reminders than I care to mention. In an attempt to account for every possible “use case”, they have created something that is far less usable than intended. All I need to do is send out invo...

It's not just a one-hit-wonder from the 80s; its true! Sure, we've all seen where we and others live via Google Maps . But this time, Microsoft has stepped it up a notch with its new "Windows Live Local" site. Now, as this is a Microsoft product, it doesn't always quite do what it says. For insatnce, it's not "Live", as my house is still occupied by the former owner as evidenced by their cars in the driveway, the salmon-colored siding (which was replaced in 2003), and the new construction at the end of the street had not started yet. However, the fact that WE can see this level of detail makes you wonder what "THEY" can see, and how "live" it really is... The level of detail is stunning, even though the pictures are a couple years old. You can even rotate the image to view it from all 4 directions! For example: My old office My Least Favorite Airport (Notice the sign on the Parking Garage) As much of the White House as they ...

OK, bad pun, but it's almost midnight here, and I'm tired... Project Raptor made its OTN debut tonight, and a preview release is available for download. I, for one, am definitely excited about this, mostly becuase the price is right: FREE!

Taking a cue from Shay Shmeltzer's recent entry , I think it would be interesting to see just where all of the HTML DB users reside. Point your browser here to chime in: http://www.frappr.com/oracleapplicationexpress

Simply pass your religion & nationality to this function to get the politically correct greeting from me. :) create or replace function HappyHolidays (p_religion in varchar2, p_nationality in varchar2) return varchar2 is l_result varchar2(255); begin if p_religion like '%christianity%' then l_result := 'Merry Christmas'; elsif p_religion like '%jewish%' then l_result := 'Happy Hanukkah'; elsif p_religion like '%pagan%' then l_result := 'Happy Winter Solstice'; else l_result := 'Seasons Greetings'; end if; if p_nationality != 'Chinese' then l_result := l_result || ' and Happy New Year'; end if; return l_result; end HappyHolidays; /

As John Scott pointed out , Oracle MetaLink is now running Oracle HTML DB. This is a major step for Oracle HTML DB's credibility, as Oracle itself made the conscious decision to re-write one of its most mission critical customer-facing systems in Oracle HTML DB over any and all other technologies.

A new HTML DB-specific Wiki has been launched at http://wiki.shellprompt.net/bin/view/Apex/WebHome . John Scott from Shellprompt.net was kind enough to lend the server, and John, Colin Sheppard and Carl Backstrom from Oracle have gotten the ball rolling by creating the first pass of content. As soon as I have a spare moment, I'll also be adding & editing content. It's great to see that any and all members of the HTML DB community can easily contribute and share their tips, tricks and insight on Oracle HTML DB. I, for one, am anxious to see what others will add, as I'm sure that there will be some excellent tips that I can learn from.

Well, at least that's what the United gate agent told us before we began to board our flight from Washington Dulles to LAX this past Tuesday. You see, we had some "very special guests" on board. United Flight #197 was officially re-named to TURKEY-1. I'm not kidding - every Air Traffic Controller from Dulles to LAX referred to our flight as this, most with bewilderment. I've been flying on United for over 10 years now, and I've seen some pretty dumb things, both on the part of them and their passengers alike. I've had 5+ hour delays for no apparent reason, seen drunk passengers denied boarding, even saw an older man punch a woman. I thought I'd seen it all. Wrong. As I was checking in, I asked if my upgrade had gone through, with little hope as it was the Tuesday before Thanksgiving in the US, one of the busiest travel days. "No, sir, I'm sorry, first class is checked in full. With 2 turkeys." "I'm sorry, but I think I jus...

Tomorrow, I'm off to Los Angeles for the remainder of the week to visit with my wife's family for Thanksgiving. While LA isn't exactly my favorite city, it should be a good time catching up with her family & friends. We're going to see a taping of the Jimmy Kimmel show on Wednesday, so that should be interesting. Amy Smart is the guest, and Def Leppard is performing outside – that alone is a reason to make the trip! I'm putting the finishing touches on my MAOP Keynote and technical session. I've also changed the topic of my Technical Session to Integrating Oracle HTML DB with the Oracle eBusiness Suite . I simply didn'y have time to get the Oracle Forms presentation in order, hence the last minute change. At one of my current contracts, I've been working extensively with the eBusiness Suite and HTML DB, so I think that this will make for a good story, with lots of advise and best practices. If you plan on attending the Keynote on Friday, I wi...

If you haven't already tried it, give Konfabulator a shot. It's basically Apple's " Dashboard " for the PC (and Mac). (Konfabulator actually came first) It used to cost $20 or so, but since Yahoo! purchased them, it is now free. Most of the "widgets" are borderline-useless, with a few exceptions: Calendar - nothing like always having a small calendar on your desk Weather - Complete with the forecast, its the next best thing to being outside Wireless Network Status - a meter which shows the signal strength of your WiFi connection There are many, many more - from dozens of clocks to your favorite movie characters who will say their funniest lines when clicked. But perhaps the most useful one I have discovered is Knut August Johansen's iTunes Companion . This one stands out above the rest, as it truly automates a tedious task - it fetches album artwork & details from Amazon.com and imports it into iTunes for your existing songs....

I'll be presenting the Keynote Presentation at this year’s MAOP Annual Training Conference on Friday, December 8th at George Washington University . My topic will be " The Best Free Tool That You're Probably Not Using " and will obviously mention Oracle HTML DB a couple of times. I'm very excited, as this will be my first keynote presentation. I've seen my share of them, and understand that the topic needs to be more business-focused as opposed to technical. As this year's conference theme is "Leveraging your Oracle Investment", I figured that would be a good theme for my presentation as well. I'm also going to be doing a technical session: Making the Switch: Migrating Oracle Forms Applications to Oracle HTML DB . Before the flame way starts, let me say that not all Oracle Forms applications should and must be migrated to anything. The point that I will attempt to convey is that Oracle HTML DB is a viable platform for some Oracle Forms m...

My article " Migrating to Oracle HTML DB " was just published in the Nov/Dec issue of Oracle Magazine. It talks about the high-level steps required to migrate from MS Access to Oracle HTML DB. To summarize: Oracle HTML DB is one of the best platforms to use when considering migrating MS Access applications to the web. However, there is no "silver bullet" approach – each MS Access application should be examined and then migrated (or not) to HTML DB accordingly.