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

Kevin Kuehl wrote in message <3700280b.1618577_at_news.apk.net>...
>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
>

In terms of performance, the word is that PL/SQL is most efficient in data-intensive cases whereas Java is most efficient in compute-intensive cases. PL/SQL is a fairly good language (resembles Ada) and embedding SQL is straightforward. You should consider using SQLJ for embedding SQL in Java.

Finn Received on Wed Mar 31 1999 - 02:43:20 CEST