Re: SQL

JB PLANTIN <sp006_at_dial.oleane.com> wrote:

>I've got to update a column adding some characters.
>
>The query i tried is the following :
>
>>update table1 set col1=concat('01',col1)
>>where col1 like '30%';
>
>It doesn't work. So, if someone could tell me if there's something
>wrong ?
>I would appreciate.

You didn't specify but it looks like you're using SQL*Plus. CONCAT is a PL/SQL function. It's not available under SQL*Plus. Received on Fri Oct 18 1996 - 00:00:00 CEST