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
