create or replace function getcol(mystr char,mytag char,seg_no integer) return char is
Result char(100);
i integer;
rl integer;
mylen integer;
--mytag char(2);
mytemp char(100);--left string seg
begin
mytemp := MyStr;
--mytag := '@@';
mylen := length(trim(mytemp));
i := seg_no;
函数如下:
-------------------
create or replace function getcol(mystr char,seg_no integer) return char is
Result char(100);
i integer;
rl integer;
mylen integer;
mytag char(2);
mytemp char(100);--left string seg
begin
mytemp := MyStr;
mytag := '@@';
mylen := length(trim(mytemp));
i := seg_no;