oracle 反向索引

create index ix_ba_emp_code_re on t_base_employee(reverse(employee_code));

select * from t_base_employee t where t.employee_code like 'dss%' or reverse(t.employee_code) like reverse('%ddd')