Re: Help: Simple Dynamic SQL question

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 Received on Sat May 26 2001 - 21:36:34 CDT