Re: PL/SQL vs Embbedded SQL
From: Steve A. Olson <solson_at_access5.digex.net>
Date: 1995/10/04
Message-ID: <44ut44$e98_at_news4.digex.net>#1/1
Date: 1995/10/04
Message-ID: <44ut44$e98_at_news4.digex.net>#1/1
Daniel Jones (jonesd_at_corp.hp.com) wrote:
: Is there a "rule of thumb" when it is more "efficient" to call a
: stored PL/SQL procedure from a batch program versus embedding
: SQL in the program?
I've found PL/SQL to be faster that embedded SQL, especially for complex data-intensive processing.
:
: The normal caveat applies here (I am new to the Oracle environment)!
:
: Thanks for any help.
:
: Dan
Steve Olson
Applied Information Technologies, Inc.
solson_at_cst.com
http://www.sqlweb.com/
Received on Wed Oct 04 1995 - 00:00:00 CET