Re: How to use in code ' '% ' '
From: philippe AZAN <philippe.azan_at_cg13.fr>
Date: Thu, 12 Apr 2001 11:46:59 +0200
Message-ID: <3AD57993.37AC5EF_at_cg13.fr>
Date: Thu, 12 Apr 2001 11:46:59 +0200
Message-ID: <3AD57993.37AC5EF_at_cg13.fr>
Hi Moshe,
i think you can do that :
1 declare
2 csi varchar2 (60) ;
3 toto varchar2(10) := 'Variable';
4 begin
5 csi := 'field like rtrim('||&1||')% ';
6 dbms_output.put_line('csi '||csi);
7* end;
SQL> /
Entrez une valeur pour 1: toto
ancien 5: csi := 'field like rtrim('||&1||')% ';
nouveau 5: csi := 'field like rtrim('||toto||')% ';
csi field like rtrim(Variable)%
Procedure PL/SQL terminee avec succes.
Phil
Moshe a écrit :
> Hi Evryone,
>
> csi := ' field like rtrim(:ss.si) || '%' '
> it is wrong
>
> how to write that '%' inside other string.
>
> Regards Moshe
Received on Thu Apr 12 2001 - 11:46:59 CEST