- Getting hold of and installing the Database engine cheaply
- Finding an ODBC driver for the database engine
Monday, December 18, 2006
Wednesday, December 13, 2006
It's been about a month since my last post and I've been busy, busy, busy. I have just got back from another trip to Prague (more on that in a later post) and my stint in Consulting Customer Services is now over and the work I did for them in APEX was very well received. Since then I've been posted to my first project outside of Oracle.
It's another project involving APEX and I'm really starting to get to grips with some of the more advanced features the product has to offer. The work I am currently involved in makes the Customer Service system I worked on seem like child's play.
For those of you not familiar with APEX, the product basically sits on top of the Oracle Database (and Oracle XE) and provides a RAD web-based development environment that allows a developer to build CRUD (Create Report Update Delete) type web applications (and more) very quickly by generating all the look and feel code itself.
When I first started developing in APEX, it seemed to be cumbersome and very difficult to do anything even remotely complex. By this I mean the built in wizards are fantastic but can be difficult to customize to your exact needs. Knowing how and where to change settings or add functionality also proved frustrating.
After using APEX for a couple of months now, I am fast becoming a convert as my proficiency has vastly improved and I have started to combine the out of the box features with both the underlying APEX PL/SQL API's which are not immediately obvious from the development environment.
My top tips would be to experimentation combined with quick scans of the developer documentation and forums if you start to get stuck. The APEX community is really gathering speed now and has vast amounts of information can be found there. Brushing up on your PL/SQL is the only other advice I can give as this is the quickest way to produce custom functionality.
As they say in the Czech Republic Na shledanou!