Oracle Open World 2012 and ADF EMG

Indeed, it’s almost “that” time of the year again, the week that San Francisco will turn red and is full of Oracle people.
There so much to do, but I still have to build my agenda.

But there are already some things to schedule…
One day, one Moscone room, one main topic…ADF EMG Sunday.
A whole day of interesting presentations on ADF, kicking off with our own:

UGF3783 – Oracle ADF Immersion: How an Oracle Forms Developer Immersed Himself in the Oracle ADF World – 9am-10am Moscone South room 305

As I wrote in a previous blog post, we created an ADF course to introduce ADF to Forms/non-Java developers.
So if you’re a Forms developer or you don’t have any java experience and want to get introduced to ADF, this will be the right session to start.

You’ll find a nice overview on Chris Muir’s blog of the other ADF EMG sessions that day.

This one will be very interesting:
UGF10464 – Oracle Fusion Middleware Live Application Development Demo – 12:45-3:45pm Moscone South room 305

A three hour live demo by Lucas Jellema, Lonneke Dikmans and Duncan Mills.
Check this out!!!

Oracle ADF Immersion

When taking a look at the tools Oracle used to develop its own products, we see that the E-business suite is build in Forms and Reports. Later, new modules were developed according Java EE standards.  Those new modules/applications were released on the same application servers that ran Forms and reports,  where they shared services and infrastructure.

Nowadays Oracle Fusion Applications is the new standard for business.
Oracle Fusion Applications is based on the Java platform, SOA and web 2.0 and is built with the Oracle Application Development Framework.
Not only Fusion Applications, but also My Oracle Support and Oracle Enterprise Manager are built with ADF.

Like Forms did in the past(and still does!), Oracle JDeveloper  offers a visual and declarative development environment for ADF.

And while Oracle uses it’s own framework to build it’s own Applications, probably a lot of companies will use the same tools to build their own Enterprise applications.

Forms and Reports developers are using Forms for years  and are very experienced in building Enterprise applications, but usual don’t have Java Experience or are even scared of Java(I know I was years ago when I read about concepts like “Polymorphism”).
iAdvise still has Forms developers and to let them experience ADF, we created the “ADF Immersion course”.
In this two day hands-on course we “immerse” them in  JDeveloper and ADF.
First day was all about ADF Business Components(entity objects and associations, view objects, Application Module, validation rules,…).
The second was about creating a User Interface: ADF Faces, ADF Model(bindings), application flow, data visualization.

A lot for a two day course, but it wasn’t meant to be as a real course. We tried to show that JDeveloper and ADF aren’t something to be scared of.  And that somebody with experience in building applications can easely start with ADF.
I think it worked out very well!  At the first try out we choosed a mixed audience of Forms developers and java developers and the best feedback we got was from a Forms developer who moved to Java years ago: “After this course every forms developer should be able to work with ADF”.
This is what we aimed for!
After the “real” courses we got the same feedback!
Mission accomplished :-)

APEX & mobile seminar

On May 12 iAdvise hosted the “APEX and mobile seminar”.
With a turnout of more than 50 customers and interested developers, it indicates that mobile development is a real hype and the demand for mobile applications is rising.

This was the starting point for Stijn who started with an overview of the current situation and evolution of mobile applications.
It became clear that as a developer you can’t ignore mobile devices in the future.
He continued with explaining the challenges in mobile development and which guidelines and strategies could help in choosing the right technology for mobile applications.

Bart took the word and focused on developing web application for mobile devices using APEX.
By combining APEX with JQuery Mobile, HTML5 and CSS3, one could develop a mobile web application rather fast and simple.
Also implementing specific mobile behaviour(eg. “swiping”) and generating extra content on a tablet are rather simple using APEX.

After Bart, Jan showed a demo about the opportunities on offering APEX applications to users as a native app.
This sounds rather strange, but is possible. He had worked out a demo using PhoneGap, a javascript library which create the communication between a web application and the API of the mobile device.
The demo showed how the APEX application from the other demos was wrapped in a native app.
This makes it possible to add a new contact in the contact list of Jan’s IPhone.

After the demos, they gaves us a look at the future of mobile development with APEX, what we could expect in APEX 4.2 and how PhoneGap will take its place in this future.

At the end Johan Byl of Hestia showed us some points which had to be taken in mind when using mobile devices in a company.
This was also very interesting for application developers.
When developing applications, they’re not always keeping in mind that there will be a maintenance phase.
Eg. The support for the application will be allright, but what about the devices itself?
How will we get the application on all the mobile devices of our company?
Can everybody connect to the company network with his or her device?
Or should we prepare a different infrastructure/security?
These and a lot of other questions were explained and answered by Johan and showed us there are a lot of things we have to think over again before putting a mobile application in production.

At the end, a lucky attendee won an IPad3.
For him, iAdvise and regarding the positive feedback for others as well, it was a succesful seminar.

If you missed this seminar, there will another one at the office of our dutch colleagues in Breda, The Netherlands on May 24 2012.

Click here to subscribe.

Gartner Report: “Modernization and Migration Strategies for Oracle Forms”

Grant Ronald brought this Gartner Report to attention on his blog: “Modernization and Migration Strategies for Oracle Forms“.

It’s great to see that our message brought to our customers and at our presentations is confirmed by this Gartner analysis

  • Upgrade to the latest version – At the moment this is Oracle Forms 11gR2
  • Modernize and integrate
  • Migrate(ADF, APEX, Open Source, …)

If you want more information on this topic, you can read my article on All Things Oracle: “What’s Your Choice for Oracle Forms?“.

Oracle Forms… the saga continues.

Last week Oracle announced the “Oracle Application Development Tools Statement of Direction“.

Oracle stays commited to the Oracle Forms customers, saying Forms will be part of Oracle Fusion Middleware 12c.
That’s right!  There will be a Forms 12c version.
And even Reports will be part of it.

My previous blogpost “Oracle Forms: upgrade…modernize…integrate” shows that you can go on with Forms and now for sure with a new version and support coming up.

On 29 March, ODTUG(Oracle Development Tools User Group) are running a webinar for Forms Developers.  One of the speakers is Grant Ronald who will give a overview on the future plans for Oracle Forms.
The other speaker is Mia Urman of OraPlayer.

You can register here for the webinar.


Oracle Forms: upgrade…modernize…integrate

iAdvise already did several presentations and seminars about Forms and Forms Modernization.
And it’s good to see that companies get the messages we are talking about.

We’ve visited a customer who still had some questions on the future of Forms.
They received complaints of users that the UI isn’t “sexy” enough, but besides that there’s nothing “wrong” with the application.

That’s why we told them there’s no need to migrate to another technology.
The demos we did about upgrading, modernizing and integration and of course the statement of direction of Oracle(Oracle Forms will not desupported) showed that we are right.

Now they’re planning the upgrade from Forms 10g to 11g.
After that they’ll take a look at how they can modernize the application(look&feel) and how they can integrate with their other applications.
That’s the way to go!

If you want to read more about our view on Oracle Forms, check out the article “What’s your choice for Oracle Forms” on All Things Oracle.

An interview with…Steven Feuerstein

Some time age one of my colleagues, An V., played with the idea to start a company magazine.  Everybody liked the idea and our manager gave a green light to create “De Poreiflash”.  Why it’s called “De Poreiflash” is a long story and I have to kill you when you don’t work for iAdvise and I tell you this.

But to keep the story short, she asked colleagues to contribute and asked me if I could write something about PL/SQL.
Sure I wanted to do that!  But about what in PL/SQL?  There so much to talk about…
I got “carte blanch”, so I started looking for topics: hints and tips, must know features, technical solutions,…
What else comes up when thinking about PL/SQL?
Indeed…Steven Feuerstein.

Wouldn’t it be cool to start with an interview with Steven Feuerstein?
I contacted Steven and he was prepared to answer some questions for “De Poreiflash”.
The first issue of “De Poreiflash” appeared two weeks ago.  An did a great job with our company magazine, it looks fantastic!
And here’s the interview how it appeared in “De Poreiflash”.
Somethings are already outdated: in the meantime Steven became a grandfather!
Congratulations Steven!

Q. Steven Feuerstein, the person with a PL/SQL obsession.  Introduction is probably not needed for people working with Oracle. Maybe a short one?

Sure. Well, yes, I think I do qualify as having an obsession about PL/SQL. I’ve written 10 books on the language and have spent most of my professional life since 1994 reading about, writing about, writing and generally wrestling with PL/SQL. Along the way, I’ve gathered some awards and related projects: I’ve been developing software since 1980, spent five years with Oracle (1987-1992), and have served as PL/SQL Evangelist for Quest Software since January 2001.

I am an Oracle ACE Director and write regularly for Oracle Magazine, which named me the PL/SQL Developer of the Year in both 2002 and 2006. I am also the first recipient of ODTUG’s Lifetime Achievement Award (2009).

In 2010, I started the PL/SQL Challenge, an online, daily PL/SQL quiz (now also offering weekly APEX, SQL and logic quizzes). In 2011, I launched PL/SQL Channel, a library of over 27 hours of detailed training on Oracle PL/SQL.

Q. How did you enter the Oracle world and got obsessed with PL/SQL?

I “fell” into the world of Oracle entirely by chance. I came out of university a Fortran programmer and ended up at Abbott Laboratories as a consultant, during which time I was introduced to databases on DEC10s and DEC20s. From there, I moved to CNA (insurance) in downtown Chicago and that was an incredibly boring job, though I did spend more time with a non-relational database while there.

So, bored out of my mind, with a newborn baby eating me out of house and home, I decided to look for a new position, and came across a Help Wanted ad looking for a person with relational database experience. Well, one of those words was familiar! So I got hold of an article on relational databases (Codd’s 12 rules), memorized that, and went to the interview. Turned out to be for a pre-sales job with Oracle. They were more interested in my ability to speak to large groups than my technical background. In any case, I was hired – the main issue for me was deciding whether or not I wanted to take a job that required wearing a suit and tie every day.

I spent a couple of years following salespeople around to accounts and doing the dog-and-pony shows for them with SQL*Plus, SQL*Forms, etc. Presales was interesting and sometimes exciting, but programming was way better, so I would constantly dabble with the Oracle tools, building little apps for my co-workers to use. This developed into TeamSell, a sales support application that caught the eye of Mike Fields, head of U.S. Sales in the early ’90s. I was drafted to join a small dev team and we started building some very cool SQL*Forms apps to support the U.S. sales force.

Then Larry canned Mike, and I was told to go back out on the road to help sell Oracle. I said no thanks, and took the first consulting job I was offered. Two years later, I saw an appeal on CompuServe for Oracle authors and I thought “Why not? I can write.” So I wrote Oracle PL/SQL Programming, which was the first independent text on PL/SQL, and it changed my life. From that point on, I was virtually a full-time student of the PL/SQL language, researching, writing, teaching, building code, etc. As I mentioned earlier, once you can structure your own time, all it takes is discipline­and reasonably good typing skills­and you can accomplish an awful lot!

I can still remember thinking as I signed the contract with O’Reilly that stipulated a book of 400 pages: “Is there really that much to write about PL/SQL?” 1200 pages later, we had to cut 400 pages to publish the first edition. Those 400 pages were all about writing PL/SQL in Oracle Forms and Reports. We should have published that immediately as a “side book.” Ah well….

Q. What’s your current job?

I am the PL/SQL Evangelist for Quest Software, have been since 2001. What this means, for the most part, is that Quest gives me lots of freedom to continue to explore the language, and support the worldwide PL/SQL community. Of course, I also do some product development, design and marketing. But I do think that Quest deserves lots of credit and a big thank you from PL/SQL developers around the world for making it possible for me to maintain my expertise and help other developers around the world.

Q. Other activities?

Ah, well, I used to play racquetball, go on lots of long bicycle rides, all sorts of things. Now, as I move through my sixth decade on Planet Earth, I find myself spending more time than ever in front of my laptop (believe me, it is not easy to write five new PL/SQL quizzes each week!) and THAT IS NOT A GOOD THING. So I struggle to keep my body in decent shop and avoid the problems associated with lots of typing and lots of staring at screens. But soon I will have a major new activity: I will be a grandfather by early November. Very exciting!

Q. About the PL/SQL Challenge…  What is it?

The PL/SQL Challenge is my latest and greatest effort to (a) coalesce an active, engaged, global community of PL/SQL developers, and (b) “download” my PL/SQL expertise from my brain into a format that is accessible to all developers and will be around long after I am gone. There are lots of sites that offer Q&A for PL/SQL and SQL; I am not interested in providing another of those. Instead, I think that developers are like “normal” human beings: we like to compete, we like to win prizes, we like to be recognized, we like to be challenged.

The PL/SQL Challenge does all of that: you take daily, weekly and monthly quizzes, competing with hundreds (and hopefully soon thousands) of other Oracle technologists. Of course, you don’t have to “compete”. You can simply take the quizzes (using, by the way, a nickname that does not reveal your true identity) as another way to deepen your knowledge of PL/SQL and related technologies like SQL and APEX.

So today it is a totally free quiz-driven learning experience. Soon, we will make it possible for you to join the PL/SQL Challenge by paying a small annual membership fee. Members will be able to utilize special features such as Practice Makes Expert, in which you can take past quizzes as often as you like, thereby sharpening your command of the PL/SQL language, and Quizbook, which will allow you to export quizzes as PDF “books” that you can use when away from the website – or to present to your manager to show her how much effort you are making to improve your technical skills.

If you haven’t registered and tried out the PL/SQL Challenge, I strongly encourage you to do so!

Q. Why should one participate?

Why not? It just takes a few minutes a day, and you are sure to either learn something new or demonstrate to everyone that you are well-versed in that particular feature of PL/SQL. When you play, you have the chance to win some prizes (ranging from O’Reilly ebooks to $250 gift cards).

Q. Some tips about developing PL/SQL?  Eg. on performance or hardcoding.

If you are not thoroughly comfortable with and applying everything on the list below, then you have a clear set of next steps when it comes to your PL/SQL training:

  • Collections
  • Autonomous transactions
  • Function result cache
  • Table functions

Q. Can you recommend books, websites, presentations,… about PL/SQL?

There are lots of excellent Q&A forums for PL/SQL, with the OTN forum being about the best. also attracts lots of PL/SQL-related questions.
Another great site for PL/SQL developers is, provided by Adrian Billington.
Tim Hall’s is also an excellent all-around resource for Oracle technologists.
I do encourage your readers to check out all the sites and resources I’ve been putting together in recent years:

Q. With your books and presentations you inspired a lot of PL/SQL developers. How does that feel?

It feels great! I expect that many companies have indirectly benefited from my writings. But what I find most rewarding is the impact I have had on the lives of individual programmers. It is not terribly uncommon to have a person walk up to me at a conference or training and offer up a variation on this story, told to me back in 1998: “I was a union electrician at a steel mill in northern Indiana. When I got laid off, I went back to school and studied Oracle programming. I got hold of your book and it changed my life. Now I have a great job, my wife doesn’t have to work and can raise our kids.” Ah, that is so satisfying!

Now, just to make sure there is no misunderstanding: I am not saying that I think everyone should follow a lifestyle in which the man works and the wife stays home with the kids. :-)

But to have a  developer tell me his or her life was changed by my writing? Wow, what could be better? So, dear readers, don’t ever hesitate to send me an email (mailto: or tell me in person about the impact my work has had on your life. I can’t get enough of that! :-)

Q. A last message to our readers?

I just turned 53 years old. I’ve been writing software rather intensively since 1980. Thirty years of programming, thirty years of (largely) sitting in front of keyboards and screens.

It’s been a great life (and I expect lots more good years to come), but I feel more and more of late that I haven’t maintained enough of a balance. There’s a very big world out there beyond my laptop, and I should be experiencing more of it.

So that will be my last message for your readers: Enjoy writing your software, but don’t let it consume your life!