I am not too sure PL/SQL is the way to go in Oracle. DBA/Data modeller role in oracle is better than doing PL/SQL work. Btween Java and Oracle see where your strengths are and which one you find more interesting. If you are comparing just PL/SQL work to Java then I would prefer Java. If you are comparing Oracle DBA/Modelling role with PL/SQL work to Java then choose based on your interest.
I agree with Arulk Pillai comments. Java programming will be more challenging and offer better career compare to PL/SQL coding. If you are moving other areas in Database like DBA then you need to think and decide based on your interests and career options.
posted 11 years ago
Responding to the above replies,
I have researched on the matter a fair bit, and have even asked to heavy-weights of both the technologies,
The result that comes forth through this interaction is as follows:
1. It is well-known fact that 2-tier technology is gaining more precedence over 3-tier. So it means that all the business logic falls in pl/sql and java or for that matter any front end is just a mean to post or receive data.
2. Java technology, due to its ever changing frameworks is perceived to be always on move and not stable.
3. Due to EJB falling short of expectations and its inherent weakness of making the system slow, has not found many takers, except the big organizations, which are using them as they have already started on it.
4. It seems that in battle of technology, the person who writes business logic for the system, is perceived to be the main person on the system. In this regard, Oracle is winning the battle.
5. Last but not the least, Oracle seems to be more stable of the two technologies and person can feel he is in grip of his career.
Please respond and share your views on the above points
In the era where everybody is working at a furious pace to master any technology, it makes sense to start a discussion right from the ground level.....FRONTEND OR BACKEND?? (In my case Java and Oracle) [ March 12, 2008: Message edited by: Adrian Perry ]
The division "FRONTEND OR BACKEND" seems pretty arbitrary, and one person's backend could be the other persons' front end. Your experience could vary (I guess depends on the market you're), but in my experience: The trend is from 3 tiers to 4 tiers (or n-tiers), particularly with the trend towards Rich Internet Applications (RIA), use of 2 tiers has scalability and supportability issues. The trend also is to move the business logic out from the database, (although still some code is needed to enforce business constraints). Java seems to be wildly popular, particularly in the "enterprise" market . PL/SQL only works in Oracle databases, thus limits your choices...