Oracle与MySql函数

Oracle:

1. 截取字符串中字符前的字符串(不包括字符)

select  Substr(SCHEDULE_CODE, 1, Instr(SCHEDULE_CODE, '(', 1)-1)  from M_SUB_TASK_SCHEDULE_LOG;

 

1. 截取字符串中字符前的字符串(包括字符)

select Substr(SCHEDULE_CODE, 1, Instr(SCHEDULE_CODE, '(ret', 1))  from M_SUB_TASK_SCHEDULE_LOG;