Re: Help: Simple Dynamic SQL question

I do need to do it, or I'll get an error...

"Daniel A. Morgan" <dmorgan_at_exesolutions.com> wrote in message news:3B106832.9ADB3AEC_at_exesolutions.com...
> Araxes Tharsis wrote:
>
> > I want to create a statement like the following, but how do I put the '
> > symbol around the variable "value" (because it is a text variable) ?!?!
> >
> > EXECUTE IMMEDIATE 'UPDATE ' || table_name || ' SET ' || field_value || '

• '
  > > || value || ' WHERE ' || id || ' = ' || p_id;
  > >
  > > Thanks,
  > > Araxes
  >
  > You don't because you don't need to.
  >
  > Daniel A. Morgan
  >