James Hambrick wrote:...I know Pl/SQL but not ETL or Oracle Forms/Reports etc...
I know you're not aiming to stay in Oracle-land anyway, but just as a heads-up: stay away from Forms/Reports. There is work around in these, but it's basically legacy work and hardly anybody uses these for new developments. Forms is really tired and out-of-date, and Reports is - and always was - a pig to use anyway. Some people are using Oracle Application Express (APEX) for web applications to replace Forms (or occasionally older
J2EE) applications, but this is a relatively small niche as far as I can tell.
So heading towards Java is definitely the better option.
In the meantime, however, if you're still going to be working in Oracle environments for a while, consider looking at modern ETL and/orBI tools, and data-warehousing. The Oracle tools are all available for download for free - you'll need to install Oracle 11g to be able to run them, so if you want to beef up your corporate bloatware skills you can do so at home. Oracle Data Integrator (ODI) is actually quite good as an ETL tool, but there are also open source options such as Talend or Pentaho. There are lots of jobs currently in ETL/BI/data-warehousing, so these skills would help you to stay in work in the corporate DB world. Also, there seems to be a trend towards a certain amount of cross-over between conventional data-warehousing/analytics systems and trendy new "Big Data" applications, so this could open some new doors for you.
Java is definitely a huge area for potential jobs, but it's worth keeping in mind what else you might be able to offer to distinguish yourself from thousands of other relatively inexperienced Java developers e.g. a solid database background is still surprisingly rare among Java developers I've worked with.
Finally, think about the skills areas that are on the rise, where you might be able to get in ahead of the rush e.g. the NoSQL database MongoDB is
growing fast and is relatively easy to get started with as an ex-RDBMS application developer e.g. with
free online training from MongoDB themselves.