Re: Newbie Question:Best development language

Thanks Ianal,

I like those guidlines - a good start for a beginner like me. I'm about to go purchase a book on pl/sql.

Cheers

ianal Vista wrote:
> "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.
Received on Sat Jun 24 2006 - 18:35:49 CDT