Hi All,
select 'abc' TEST1 from dual
union all
select 'abc,abc1' TEST1 from dual
so i have to use
if TEST1 is not null then
TEST1 ||',';
end if;
but in the output abc, is printing , so i need to remove comma if TEST1 is having only one value.
Can you please help me?