declare
a varchar2(100);
v_output varchar2(100);
begin
a:='HCL HR';
select rtrim(replace('HCL HR',' '),'*') into v_output from dual;
dbms_output.put_line(v_output);
end;
a varchar2(100);
v_output varchar2(100);
begin
a:='HCL HR';
select rtrim(replace('HCL HR',' '),'*') into v_output from dual;
dbms_output.put_line(v_output);
end;
No comments:
Post a Comment