I am a PL/SQL developer for 6 years now. I recently received a job offer to develop in Oracle Forms 6.0, Reports and HTMLDB. I think these are older technologies. I don't know if it is a step back to work on these products, but I do know that I want to develop in Oracle Database 12c, Application Express, and other new technologies. One thing I have found is that it is more and more difficult to find a job in Brazil that only requires PL/SQL experience.
And this is what I said:
No doubt about it, Oracle Forms 6.0 and HTMLDB are not the leading edge of PL/SQL-based Oracle technologies!
You would be much better off working at a company that has upgraded to Oracle Database 12c, has a strong commitment to fully leveraging SQL and PL/SQL, uses Application Express for website and intranet development, etc.
But keep the following in mind:
- There are not a whole lot of companies who have upgraded to 12.1.
- I probably don't have to tell you this, but you have to live in the world as it is, not how you want it to be.
So maybe you should take that old technology job. If you cannot afford to keep looking, that job might end up being a great platform for you to explore the newer technologies as part of planning their upgrade strategy.
In other words: take the interview and then find out what their future plans. You could end up being in the right place at the right time to take the lead in working with 12.1, APEX and more. You could become the in-house superstar and have a long, successful career right there.
And regardless of whether you take the job or hold off, continuing your search, there is absolutely no reason to put off learning about and using the latest technologies.
Download Oracle Database 12c here.
Sign up for your free APEX workspace here.
And then, most important of all, pick a project you'd like to work on. In other words, make it as real as possible.
Build an app to keep track of lost kittens in your neighborhood, or a simple to-do list manager or....you name it. Pick an app you really like and then replicate it. You don't have to come up with a wildly, new original idea to hone your skills.
You just need focus and motivation.
Hope this helps!