Question

oracle存储过程怎么截取字符串

Answer 1

之前我保存的经典的方法，你可以参考下
首先创建一张表t_al_test_sy
字段分别为：pid,str_id,str_dm,str_mc；
存储过程如下：
create or replace procedure p_al_output
as
str_id varchar(60);
str_dm varchar(60);
str_mc varchar(800);
str_start number;
str_len number;
str_length number;
str_end number;
str_count number;
str_content varchar2(800);
str_partcontent varchar2(800);
str_iscontent number;