Saturday, April 4, 2009

iPhone Application with Oracle Apex and iWebKit

Created the mobile version of Philadelphia Cricket League website for iPhone using Oracle Apex, JQuery and iWebKit. It's came out pretty neat, it's a work in progress but I had to post this in sheer excitement :). All this without actually using the Apple iPhone SDK.

Like me if you don't have an iPhone/Touch, you can always view it in

Corresponding thread in Oracle Apex Forum:

Sunday, March 22, 2009

Oracle Apex Showcase Site Updated

Inspired by the SmartGWT Showcase, I updated my Oracle Apex showcase. It has demos for Forms, Lists, Calendars and also a whole bunch of screens related to JQuery integration. It's still a work in progress, but has decent amount of stuff to showcase the power of Oracle Apex and it's possibilities.

Monday, March 2, 2009

New Cricket Club Portal with Oracle Apex/JQuery

Check out the new cricket club portal developed with Oracle Apex/JQuery. It has host of features including automatic statistics generation, storefront integration with Google checkout among a few of the features. A club should be able to perform all their tasks, such as posting announcements, headlines, matches, match signups, team selection, online surveys, live chat among other things without any technical knowlege. Check it out, login with the sample user id's provided and let me know if you or someone is in need for a portal for your sports club, it's not just limited to Cricket, it can be expanded for all sports!!! More details at

Here's the direct link:

Tuesday, February 3, 2009

Page Access Protection

I believe since version 3.1, the pages now have Page Access Protection. Use this feature to the fullest to protect the sensitive pages in your application. Without this malicious users can tamper with the URL and do harm. It's available under Page Attributes -> Security -> Page Access Protection. I recommend using "Arguments must have checksum". This will ensure that a checksum is appended to the URL that is specific to only that specific instance of the URL and cannot be manipulated.

In addition, you should also use another mechanism to secure the sensitive buttons, pl/sql processes in the page.

Sunday, February 1, 2009

Accordion using JQuery

Created this demo site where I will be posting new things I try out. It now has a page to show how to get JQuery accordion running within Apex, it's so simple to setup and use. Hope you guys like it. JQuery is so cool, this weekend was dedicated to it. Why didn't I look into it earlier? :)

Updated: 2/2/09: Also added DatePicker (page level and application level)

My first screencast about the Cricket Club Portal

Check this screencast of the upcoming Cricket Club Portal that's under development. Wanted to create a sneak peak to garner the interest. It's developed using Oracle Apex. :)

Cricket Club Portal screencast

Wednesday, January 28, 2009

Sunday, January 18, 2009

Incorporating Captcha on Oracle Apex site

Check out this fantastic article by Patric on integrating Captcha on Oracle Apex. It works beautifully.

Friday, January 9, 2009

Cool JavaScript Thumbnail viewer


Check out this handy reference to enable openId on your website. OpenId enables your clients to login to your website using one single userid/password, taking the hassle out of remembering multiple userids/passwords for each site. If you are using yahoo, gmail, blogger, wordpress etc. you already have openid, you just need to enable them and use it.

Check this handy reference:

To learn more about openId, check out the official website at:

Yahoo Maps API

You can use Yahoo Maps API to integrate Yahoo maps within your application, it's pretty simple and neat. You can even display traffic information. Check out:

Google Chart API

Google Chart API allows you to dynamically create charts by just passing parameters to an URL, it's pretty amazing. You can generate all kinds of charts, check it out...

Check this simple example:,40&chs=250x100&chl=Hello|World