GeezerVison is showing github.com — utPLSQL/examples/between_string/betwnstr.sql at develop · lmaciuga/utPLSQL

Expand file tree

betwnstr.sql

Copy path

More file actions

9 lines (9 loc) · 299 Bytes

Copy path

9 lines (9 loc) · 299 Bytes

Copy raw file

Download raw file

Open symbols panel

Edit and raw actions

create or replace function betwnstr( a_string varchar2, a_start_pos integer, a_end_pos integer ) return varchar2 is

l_start_pos pls_integer := a_start_pos;

begin

if l_start_pos = 0 then

l_start_pos := 1;

end if;

return substr( a_string, l_start_pos, a_end_pos - l_start_pos + 1);

end;