Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Dynamic SQL simple question
Hello,
It sounds like what you want is to make your statement like this:
EXECUTE IMMEDIATE 'UPDATE ' || table_name || ' SET ' || field_value ||
' = '''||value||''' WHERE ' || id || ' = ' || p_id; --- That's three
single quotes together
HTH
R. Steven Brown
"Araxes Tharsis" <pnrmaia_at_hotmail.com> wrote in message
news:9epfif$gob$1_at_venus.telepac.pt...
> 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
>
>
>
>
Received on Sat May 26 2001 - 20:42:10 CDT