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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Using bind variables

Re: Using bind variables

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Mon, 18 Apr 2005 22:13:34 +0200
Message-ID: <h55861d78pck1dsufbhkhaictaf4c7sfd7@4ax.com> 





On Mon, 18 Apr 2005 20:03:11 GMT, "Dave" <x_at_x.com> wrote:



>only if the literals change which in a view they dont, its all about shared 

>sql and that sql is shareable 




This explanation is a bit inaccurate, as a view is a *compiled
object*, so by definition you can't have bind variables in them.



--
Sybrand Bakker, Senior Oracle DBA


Received on Mon Apr 18 2005 - 15:13:34 CDT












Original text of this message













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