Tuesday, 5 July 2011

SUBSTR Using joining two starings

 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;

No comments:

Post a Comment