Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Dynamic SQL simple question

Re: Dynamic SQL simple question

From: R. Steven Brown <rstevenbrown_at_earthlink.net>
Date: Sun, 27 May 2001 01:42:10 GMT
Message-ID: <SXYP6.24196$9D5.2156199@newsread2.prod.itd.earthlink.net>

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US