Re: PL/SQL or Java in Oracle 8i?

Oracle8i allows development in SQLJ (SQL in Java), Entreprise Java Beans and pure Java for stored procedures, functions and triggers.

Kevin Kuehl wrote:

> 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 Wed Mar 31 1999 - 04:52:07 CEST