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;