Monday, 4 July 2011

Sub string using Letters

 declare
  a varchar2(100);
  v_output varchar2(100);
  begin
  a:='HCL HR';
  SELECT substr('HCL HR',instr('HCL HR',' ')+1) into v_output from dual;
  dbms_output.put_line(v_output);
  end;


output
HR

No comments:

Post a Comment