Tuesday, June 19, 2018

Create a function to remove the left character position of string - DBMS (Function)


create or replace function display(char in varchar2,no in number)
return varchar is ans varchar2(5);
begin
ans:=SUBSTR(char,0,no);
return ans;
end;

No comments:

Post a Comment