Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: advantages of storing SQL in stored procs

Re: advantages of storing SQL in stored procs

From: Dogan Cibiceli <dogan_at_mediaone.net>
Date: Tue, 22 Aug 2000 00:12:23 GMT
Message-ID: <Hzjo5.38952$_s1.488985@typhoon.ne.mediaone.net> 






since you use the same sql, parsing done is decreased to a minimum... I
guess... Well maybe not... or....



"NetComrade " <andreyNSPAM_at_bookexchange.net> wrote in message
news:37bf1062.21439618_at_news.earthlink.net...


> I ask/make my developers to write SQL using bind vars, are there any

> clear advantages in doing it in PL/SQL, performance wise?

>

> Thanx.

Received on Mon Aug 21 2000 - 19:12:23 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US