PL/SQL or Java in Oracle 8i?

From: Kevin Kuehl <kkuehl_at_apk.net>
Date: Tue, 30 Mar 1999 01:30:01 GMT
Message-ID: <3700280b.1618577_at_news.apk.net>

[Quoted] [Quoted] I am a new user to Oracle and will start a relatively simple application using Oracle 8i. I know how to program in Java but I don't know PL/SQL. I expect to only have a few simple stored procedures for doing things like summing up a bunch of values in my rows and then inserting the result in another table for later use.

Should I mess with PL/SQL or just stick with Java? Although my history table will be rather large (about 400M rows), the stored procedures can run at night when no one is using the system. Does PL/SQL have enough goodies already available to make it worth learning for someone who doesn't already know it and will not be messing with pre-Oracle 8i? As you can probably tell, I am not a DBA by profession. :-)

Thanks for your help,
Kevin Kuehl
kkuehl_at_apk.net Received on Tue Mar 30 1999 - 03:30:01 CEST