replace for stirng

variable:=REPLACE(PARM_ECLS_EXC,',',''',''');

 system flush::
 
alter system flush shared_pool;

DECODE::

decode(T_CONTRACT_NAME,null,decode(T_STREET_LINE1,null,'No Contract Name',T_STREET_LINE1),T_CONTRACT_NAME ) decode,