Re: Newbie Question:Best development language

"swaxolez" <mvsunstar_at_yahoo.ca> wrote in news:1151189212.351191.147220_at_r2g2000cwb.googlegroups.com:

> Thanks Mark,
>
> I guess I'm still a little confused about where to use pl/sql instead
> of java. The messages I have read so far seem to indicate that
> procedures are faster in pl/sql. Furthermore, I'm wondering if this
> speed difference is also noticeable between pl/sql and .net
> procedures.
>

PL/SQL runs inside the database.
.NOT runs outside the database.
When dealing with LARGE results sets the movement of data to where .NOT is running does not scale well.

Tom Kyte uses the following guidelines:

1) When possible use SQL.
2) When SQL not possible, use PL/SQL
3) When PL/SQL not possible or when lots of math needs to be done use Java.