Re: substitute object name with bind variables

  • From: David Sharples <davidsharples@xxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Tue, 11 Jan 2005 20:30:32 +0000

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@xxxxxxxxxxx
<geraldine_2@xxxxxxxxxxx> 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
--
//www.freelists.org/webpage/oracle-l

Other related posts: