| How to get back to Oracle latest versions. [message #668370] |
Mon, 19 February 2018 20:00  |
anasjamil
Messages: 31
Registered: April 2008
Location: Sydney
|
Member |
|
|
Hello to all,
I must say this forum helped me a lot when I was an oracle developer a decade ago.
I am writing to request everyone to provide me feedback about how to get back to the industry since I left the development due to some unavoidable circumstances.
I used to be an oracle developer using Oracle 10g as database and Developer 6i (Forms & Reports). However, since it has been a long time, I am not sure exactly which forms & reports version is latest in the market?
Moreover, since I am rusty with my SQL skills including stored procedures, triggers (both at form level and database level), I need your expert opinion about ways to get back to oracle development based on current trends in the market?
Regards,
anas jamil
|
|
|
|
| Re: How to get back to Oracle latest versions. [message #668377 is a reply to message #668370] |
Tue, 20 February 2018 00:51  |
 |
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
|
Senior Member
Account Moderator |
|
|
If you want to continue where you left, nothing much changed ... Forms is still here (version 12c) and runs on web so the "background" is different (i.e. it is not a client-server any more). Though, as far as I can tell, simply by reading discussions, people throughout the world still use Forms 6i, especially in India. 10g database is also alive and kicking, mostly for those who - due to different reasons (be it money or whatever else) - didn't upgrade to a more recent version.
SQL has changed - not that "old" functionalities won't work, but some new great ones appeared so you might need to take some time to learn what's new. PL/SQL is still here (triggers, stored procedures).
Basically, if you still remember how to get things done, you'll be able to do it again. Though, you might find a better, simpler, faster ways to accomplish that.
As of current trends: although Forms is here and Oracle continues to support it, it seems (to me) that it isn't that popular as it once was. Although it works well, it is ugly from today's point of view. JDeveloper? No idea, I don't speak Java & don't plan to learn it because a) I don't have to, b) (even more important) I don't like it. ADF? I've heard, from a man who attended OpenWorld last year, that in 3 days there was no lecture about it; if he lied, I'm lying too. Apex (Application Express) seems to be quite popular lately.
So ... refresh your (PL/)SQL knowledge. You'd then be able to use any other tool that supports it.
Someone else here might have another point of view, which doesn't have to match mine. I'm not trying to mislead you - the above is just how I see things right now.
|
|
|
|
| Re: How to get back to Oracle latest versions. [message #668380 is a reply to message #668370] |
Tue, 20 February 2018 05:34 |
John Watson
Messages: 8962
Registered: January 2010
Location: Global Village
|
Senior Member |
|
|
|
The company I work for has been asked a few times to work on projects to move from Forms to APEX. A lot of people seem to be doing this, and there do not seem to be many people around with practice at it. There are some techniques that are supposed to help, but often APEX guys just say "impossible to convert, we'll write the whole thing from scratch" and I do wonder if that is really the best solution. That is the area I would look at at if I had your background.
|
|
|
|
|
|
|
|
| Re: How to get back to Oracle latest versions. [message #668397 is a reply to message #668389] |
Wed, 21 February 2018 04:05 |
|
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
|
Senior Member
Account Moderator |
|
|
Yes, 12c is the last downloadable version (although I see documentation for 18c is available on OTN).
As of news - every documentation set contains "New features guide" - read it and you'll know the differences.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
