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

Home -> Community -> Mailing Lists -> Oracle-L -> Re: substitute object name with bind variables

Re: substitute object name with bind variables

From: David Sharples <davidsharples_at_gmail.com>
Date: Tue, 11 Jan 2005 20:30:32 +0000
Message-ID: <be592d550501111230263cf944@mail.gmail.com>


you cant bind a table name - and think about it - why would you want to because the sql is not the same

On Tue, 11 Jan 2005 20:19:34 +0000, geraldine_2_at_comcast.net <geraldine_2_at_comcast.net> wrote:
> Igor,
> Thanks for your response.
>
> I was probably not clear with my question. I can write the way you suggested but tabname.table_name will be replaced by literal strings.
>
> ie
> delete table1 where id=:b2;
> delete table2 where id=:b2;
> delete table3 where id=:b2;
> etc.
>
> I would like to know if there is an alternative to writing the code to make use of bind variables -
> delete :b1 where id=:b2

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Jan 11 2005 - 14:31:58 CST

Original text of this message

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