Re: little question
Date: Wed, 24 Jan 2001 23:43:15 -0600
Message-ID: <i0Pb6.136$at3.169611_at_nnrp3.sbc.net>
"Juan Miranda" <jmiranda_at_mundo-r.net> wrote in message
news:94mrot$8e82_at_cesio.mundo-r.com...
> I need to insert the following expresion:
> to_char(F_DELIM_RETE.getMaxLencavoDrop(id_delim_rete),'990')
> into a varchar2 field.
>
> The problem is the '
> I tried with ' , ' ', ". no way.
>
> How can i proceed ?
>
> Thanks
>
>
> SQL> update m_txt_token set nome_campo=
> 'to_char(F_DELIM_RETE.getMaxLencavoDrop(id_delim_rete),'990')' where
> nome_campo like 'house';
>
have you tried replacing the embedded single quotes with two single quotes:
update m_txt_token
set nome_campo=
'to_char(F_DELIM_RETE.getMaxLencavoDrop(id_delim_rete),''990'')'
where nome_campo like 'house';
the two single quotes will be evaluated as a single quote within the string constant, which looks suspiciously like an expression to be evaluated. if you're not wanting to store a constant string, then remove the quotes from around the expression:
update m_txt_token
set nome_campo=
to_char(F_DELIM_RETE.getMaxLencavoDrop(id_delim_rete),''990'')
where nome_campo like 'house';
HTH Received on Thu Jan 25 2001 - 06:43:15 CET