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: Daniel A. Morgan <dmorgan_at_exesolutions.com>
Date: Sun, 27 May 2001 00:09:11 -0700
Message-ID: <3B10A817.CE874B4D@exesolutions.com>

"R. Steven Brown" wrote:

> 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
> >
> >
> >
> >

He may well want to. The problem is that if he does it won't work.

Daniel A. Morgan Received on Sun May 27 2001 - 02:09:11 CDT

Original text of this message

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