PL/SQL similar to Java?

[shagymoe]

I have just started learning PL/SQL and I was wondering if learning it will help me if and when I decide to learn Java.

I have already written a few small programs in Java, but don't know it well. However, I'm thinking that it would be a good idea for me to learn it and use it in conjunction with Oracle.

[reydp]

Oh yeah.... you're on the right truck.
In fact you can even use PL/SQL to write web pages,
here you will learn to use packages like OWA_UTILS, HTP, etc.

It will always complement your knowledge with JAVA.

good luck.

[julian]

Originally posted by reydp
Oh yeah.... you're on the right truck.
In fact you can even use PL/SQL to write web pages,
here you will learn to use packages like OWA_UTILS, HTP, etc.

It will always complement your knowledge with JAVA.

good luck.

OWA_UTILS??

[reydp]

Ok Julian, you got me there.
it should be owa_util /*WITHOUT S*/
example:
exception
when no_data_found then
owa_util.redirect_url('/pls/dummy/getit');

happy now? hehehe :-)

[Zaggy]

It may help you or hinder you, it all depends on your ability to adapt and learn. I say this becuase, I have seen people that are great at procedural languages and have trouble getting use to the OO paradigm. Once I learned Java and OO, you can write Java in a non-OO way(speaking from experience), I wanted to do everyting in OO, which you cannot. If you do not know OO, I suggest you learn it before you learn Java and even learn UML before Java. This what I suggest for a smooth transition to Java syntax, Java methodology and its large library set. Also, if you are going to do GUIs in Java learn the Model-Controller-View pattern. I have created and maintained web pages in PL/SQL and Java. I suggest using Java's JSP and servlets for many reasons like:
-- Platform/Vendor independent
-- OO flexibilty
-- Multiple App. servers, some free and good
-- More common and in demand.