oracle instr,substr 截取字符串
时间：2021-07-01 10:21:17
帮助过：26人阅读
lv_str varchar(
500);
begin
lv_str := ‘abcd$xxx‘;
dbms_output.put_line(instr(lv_str, ‘$‘));
dbms_output.put_line(substr(lv_str, 0, instr(lv_str,
‘$‘)
- 1));
dbms_output.put_line(substr(lv_str, instr(lv_str, ‘$‘)
+ 1));
end;
oracle instr,substr 截取字符串
标签：weight ora AC bsp 截取字符串 post instr varchar rac
